Forum Discussion
Analyze in Excel Via Get Data From Power BI Dataset
I'm trying to analyzie power bi datasets in excel but I'd like to make the connection from Get Data -> From Power BI Dataset as shown here: https://docs.microsoft.com/en-us/power-bi/collaborate-shar...
The .ODC file creates an XMLA endpoint client connection.
If you want an alternative you can connect from Excel to the "Analysis Services" instance of your Power BI dataset. There are some subtle differences, but mostly you'll get the same result as with the .odc
The server and database fields need the connection string from your dataset properties
server: powerbi://api.powerbi.com/v1.0/myorg/<workspace name>
database: <dataset name>
Good luck when you have situations with multiple workspaces or datasets with the same name...
Thanks Ibendlin, I'll have a go next week 🙂