| 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...") |
|||
| Line 1: | Line 1: | ||
| + | Power BI connections support MDX and DAX, so you can use both [[Grids]] and [[Tabular]] report types. | ||
| + | |||
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. | ||
Revision as of 10:56, 16 September 2016
Power BI connections support MDX and DAX, so you can use both Grids and Tabular report types.
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.
