Forum Discussion
Solved
Create SQL Server Linked Server for PowerBI-Dataset?
With the addition of XMLA end points, is it an option to now create a Linked Server to the PowerBI data set? Our Tabular SSAS models are managed programatically via Linked Server. I'm hoping I ca...
Hi scurrp,
If you mean use SQL linked server connect to power bi dataset, it is possible.
AFAIK, power bi service datasets host on azure blob data storage, so you can refer to the following tutorial to know how to use sql server connect to azure blob storage:Tutorial: Use Azure Blob storage service with SQL Server 2016
If you mean get data from the linked server, it seems not to support. Perhaps you can try to use other connector drivers or submit an idea to improve this.
Regards,
Xiaoxin Sheng
Hi there
As far as I know linked servers are not supported to the Power BI Premium.
As far as I know linked servers are not supported to the Power BI Premium.