Forum Discussion
How to load a PowerBI symantic model as source for Power Query in Excel
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.
Thanks Anonymous for the comprehensive explanation.
The thing that strikes me is that I am able to (in the same file) add a live connection to the semantic model I need and create a pivot as per below:
However in the same file, I can't create a source on PowerQuery, to that semantic model as the option for PowerBI is not there.
Maybe I am doing something wrong? Appreciate your time and effort here!
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.
