Linked server to semantic model

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.

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!