PPU workspace as a linked server

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.