Trying to use Datamarts as a cache layer for a couple of models.
1. A table with 20mln rows loaded into Datamarts from a Dataflow without any issues.
2. Trying to load the table into a model in Power BI Desktop. Loading stops after several thousands rows.
Checking the approach using SQL Server Managment Studio. A query can load the whole table without any issues.
When you create a datamart , system will also create a dataset , so I don't quite understang that you said "can not load a table from a datamart into a Dataset" . Can you describe your process in detail to me ?
Community Support Team _ Ailsa Ta