Forum Discussion
Power Participantcan't import a semantic model into Power BI Desktop
I have Fabric free trial capacity, and a semantic data model has been created in Fabric workspace. By default, I can connection Power BI Desktop to the semantic model under Direct Lake mode. But here I need to run some DAX query which need access to the meta data of the semantic model. This is not allowed in Direct Model, so I try to connection Power BI Desktop to the semantic mode using import mode (see demo from Chris Web https://blog.crossjoin.co.uk/2025/05/04/documenting-power-bi-semantic-models-with-fabric-data-agents/).
However, when I import the semantic model, I got an error message:
yes that 1m row cap is a known limitation when importing a fabric semantic model into PBI desktop in Import mode, it is imposed by the XMLA endpoint query result size limit
To work around, you can try the below:
Reduce the dataset size by filtering or aggregating before import.
Use DirectQuery to the XMLA endpoint instead of full import (lets you query metadata via DAX Studio or Tabular Editor without pulling all data).
Upgrade to a paid fabric capacity (F-SKU) -> larger capacities allow higher XMLA query result limits.
Solved: Re: Size limit per Semantic model - Microsoft Fabric Community
3 Replies
- Vinodh247
Super User
yes that 1m row cap is a known limitation when importing a fabric semantic model into PBI desktop in Import mode, it is imposed by the XMLA endpoint query result size limit
To work around, you can try the below:
Reduce the dataset size by filtering or aggregating before import.
Use DirectQuery to the XMLA endpoint instead of full import (lets you query metadata via DAX Studio or Tabular Editor without pulling all data).
Upgrade to a paid fabric capacity (F-SKU) -> larger capacities allow higher XMLA query result limits.
Solved: Re: Size limit per Semantic model - Microsoft Fabric Community
- Jeanxyz
Thanks, to solve the 1 mn row limite, I managed to create an aggregation query in Power Query.
= AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Stock_Fabric_test", "Stock_Analysis_Fabric", [Query="EVALUATE addcolumns(values(fact_stocks[Ticker]), ""price"", average(fact_stocks[Close]))"])
v-venuppuCommunity Support
Hi Jeanxyz ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Vinodh247for the prompt response.
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.
Thank you.
