Forum Discussion

scurrp's avatar
scurrp
Frequent Visitor
6 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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