PPU workspace as a linked server

[ray_codex]

Hi,

Has anyone managed to register a PPU workspace as a Linked server to an On prem SQL server? I have tried all kinds of ways to add it, but I can't get it to connect. I have MFA on my user account, that could maybe cause an issue. I can connect to the workspace the normal way. 

I'm trying to get data from the dataset to SQL tables, issues with the REST API made me look for an alternative. Using the xlma endpoint would be gold and much more convenient.

[Anonymous · Accepted solution]

Hi, @ray_codex 
Thanks for reaching out to the Microsoft fabric community forum.

As far as I know, Power BI workspaces cannot be directly configured as linked servers. Below is a screenshot of the relevant response: Workspaces are also part of powerbi.com. 

For more details, please refer to the documentation:

Solved: Create SQL Server Linked Server for PowerBI-Datase... - Microsoft Fabric Community

However, as you mentioned, you can use Analysis Services connections:

Additionally, you can use the following API to export to Excel format:

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo

For more details, please refer to the documentation:

How to use Power BI Rest API to export the Power B... - Microsoft Fabric Community

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.