| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Power BI Cloud"
(Created page with "To connect to the PowerBI.com hosted data you need to download the “Analyze in Excel” file from PowerBI.com. To get this click “…” next to a Dataset. When you do th...") |
|||
| (12 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
| + | Power BI connections support MDX and DAX, so you can use both [[Grids]] and [[Tabular]] report types. | ||
| + | |||
| + | ===Standard Edition=== | ||
| + | |||
To connect to the PowerBI.com hosted data you need to download the “Analyze in Excel” file from PowerBI.com. To get this click “…” next to a Dataset. | To connect to the PowerBI.com hosted data you need to download the “Analyze in Excel” file from PowerBI.com. To get this click “…” next to a Dataset. | ||
| Line 8: | Line 12: | ||
The connection file does not need to be downloaded for each workbook, you can reuse it. | The connection file does not need to be downloaded for each workbook, you can reuse it. | ||
| + | |||
| + | [[Image:PBI_AnalyseInExcel.png|800px|centre]] | ||
| + | |||
| + | Download the Excel driver if required. | ||
| + | |||
| + | [[Image:pbi_analyseinexcelupdates.png|800px|centre]] | ||
| + | |||
| + | ====Connecting as the Application Pool user==== | ||
| + | If all user connections can be made as the Application User, then a [[Connection Mapping]] file can be used to connect all reports using saved credentials. | ||
| + | |||
| + | This [[File:PowerBI Connection Mapping.zip|template file]] can be used as a starting point. It should be filled in with the datasource and identity provider IDs, as well as the desired credentials to connect to the datasource. | ||
| + | |||
| + | ===Premium Edition=== | ||
| + | |||
| + | If you have Power BI Premium and are using MFA then you must use the new Premium (powerbi://) connection type when connecting in XLCubed, introduced in [[Version 9.2]]. The server address can be copied from the workspace settings dialog, and will be of the form | ||
| + | |||
| + | <code>powerbi://api.powerbi.com/v1.0/myorg/[your workspace name]</code> | ||
| + | |||
| + | You can find this in the PowerBI workspace settings | ||
| + | [[Image:PowerBIXmlaSettings.png|300px|centre]] | ||
| + | [[Image:PowerBIXmlaString.png|300px|centre]] | ||
| + | |||
| + | More information about this can be found in a Microsoft blog https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview/ | ||
| + | |||
| + | If you have duplicate workspace names you can specify the correct one using the ObjectIDGuid as described here: https://docs.microsoft.com/en-us/power-bi/service-premium-connect-tools#duplicate-workspace-name | ||
| + | |||
| + | |||
| + | [[Image:pbi_connectscreen.png|centre]] | ||
Latest revision as of 15:59, 20 September 2023
Power BI connections support MDX and DAX, so you can use both Grids and Tabular report types.
Standard Edition
To connect to the PowerBI.com hosted data you need to download the “Analyze in Excel” file from PowerBI.com. To get this click “…” next to a Dataset.
When you do that you’ll be prompted to install a driver, you will need to install that if you have not done so already.
Then select the Power BI connection type in XLCubed and pick the “.odc” file you just downloaded.
You’ll be prompted for your email/password, fill those in and the connection will be made.
The connection file does not need to be downloaded for each workbook, you can reuse it.
Download the Excel driver if required.
Connecting as the Application Pool user
If all user connections can be made as the Application User, then a Connection Mapping file can be used to connect all reports using saved credentials.
This File:PowerBI Connection Mapping.zip can be used as a starting point. It should be filled in with the datasource and identity provider IDs, as well as the desired credentials to connect to the datasource.
Premium Edition
If you have Power BI Premium and are using MFA then you must use the new Premium (powerbi://) connection type when connecting in XLCubed, introduced in Version 9.2. The server address can be copied from the workspace settings dialog, and will be of the form
powerbi://api.powerbi.com/v1.0/myorg/[your workspace name]
You can find this in the PowerBI workspace settings
More information about this can be found in a Microsoft blog https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview/
If you have duplicate workspace names you can specify the correct one using the ObjectIDGuid as described here: https://docs.microsoft.com/en-us/power-bi/service-premium-connect-tools#duplicate-workspace-name
