Forum Discussion
Solved
How to load a PowerBI symantic model as source for Power Query in Excel
Dears, hope you can help me with the following. I am trying to do some data transformations in Excel Power Query on data that is from an existing connection that I got through: Data - Get Data - From...
Hi timothius ,
As you said, connecting to the semantic model is Live connection mode, and Power Query is not supported in Live connection mode. There is no other mode to connect to a semantic model except Live connection mode, so it is true that you can't connect to a semantic model in the Power Query Editor.
This link has a detailed list of Power Query data sources in Excel:
Power Query data sources in Excel versions - Microsoft Support
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I can connect to a Power BI semantic model in import mode from Excel through Get Data, From Database, From SQL Server Analysis Services Database (Import).
Some notes:
- In Server prompt, enter the workspace's connection link as shown in your workspace settings (i.e. powerbi://api.powerbi.com/v1.0/myorg/aWorkspaceName).
- In Database, enter the name of the semantic model you want to connect to, or select one from Navigator in the next steps.
- For access, sign in with Microsoft account instead of Windows or Basic.
- Just in case these are factors for a successful connection, I have a Pro license in a workspace with Premium capacity and XMLA read/write enabled.