Forum Discussion
Power Participantcan't import a semantic model into Power BI Desktop
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
Community SupportHi 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.