topic Linked server to semantic model in Developer

Linked server to semantic model

graygraybear — Wed, 21 Aug 2024 20:01:44 GMT

We migrated SSAS to Power BI semantic model. How can I build a linked server to access power BI semantic model through openquery? Thanks!

Re: Linked server to semantic model

Anonymous — Thu, 22 Aug 2024 01:55:56 GMT

Hi @graygraybear ,

According to statement, I think you can try XLMA EndPoint to connect to PBI semantic model with SSAS.

You may refer to below blogs to learn more details.

For reference:

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Power BI Datasets via XMLA Endpoint | by Smagulova Meruyert | Medium

Best Regards,
Rico Zhou

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

Re: Linked server to semantic model

graygraybear — Thu, 22 Aug 2024 03:26:55 GMT

Hi Rico,

Thanks so much for your reply! My situation is: I need to combine on-premise sql server data and some data from Power BI sematic model migrated from SSAS in one store proc, and this proc is going to be called from on-premise sql server. Even though I can connect to power BI via XMLA, I have trouble to integrate the data into my local sql server queries.

Thanks!