Forum Discussion
Using Import mode for power bi dataset in Analysis Services
Hi Anonymous , Thank you for reaching out to the Microsoft Community Forum.
There is no hidden row limit when importing a Power BI dataset over the XMLA/Analysis Services endpoint, the engine returns whatever the semantic model currently contains. The behaviour you observed (3.5M -> 5M after adding an index) is consistent with a calculated table or partition that was not processed/rebuilt; your edit forced the model to re-evaluate and repopulate the table, which restored the full 5M rows.
Connect to the same dataset with SSMS, DAX Studio or Tabular Editor and run the partitions DMV (SELECT [Name],[RowCount] FROM $SYSTEM.TMSCHEMA_PARTITIONS;) and a DAX row count (EVALUATE { COUNTROWS('YourTableName') }) to confirm what the model currently stores. If the model shows ~3.5M, run a Process/Table or Process/Partition (or TMSL Refresh/ProcessFull) against that calculated table or its partitions to force a full rebuild. If it shows ~5M but Desktop imports 3.5M, ensure your import is pointed at the exact Initial Catalog (dataset/version) and that your identity has full visibility. To prevent recurrence, schedule explicit processing after any source update or avoid relying on implicit query edits to trigger model processing for calculated tables.
DAX Queries - DAX | Microsoft Learn
Process Database, Table, or Partition (Analysis Services) | Microsoft Learn
Partitions in Analysis Services tabular models | Microsoft Learn
Memorable MemberAnonymous I am not aware of any limitation like that. You might want to try this technique: How to migrate Power BI datasets to Microsoft Analysis Services models [Tutorial]
I am importing dataset from power bi service using Get Data -> Analysis services option and getting the connection string from the settings of power bi dataset in app.powerbi.com. My aim is to import data from a dataset without row restriction