Forum Discussion
joining 2 large semantic models (live connection direct query)
Thank you. I have tried aggregations, which helps when it is one fact table, but I have 2 large fact tables, and when joined together, causes the error.
I think I will need to go back to the source and extract what I need from there rather than connecting to the live Power BI semantic models.
Hi TrevLc
You may consider using Aggregations in Power BI. Aggregations in Power BI can improve query performance over large DirectQuery semantic models. By using aggregations, you cache data at the aggregated level in-memory. Aggregations can significantly reduce the volume of data needed for your visualizations, potentially avoiding the 'maximum allowed size' error. To learn more about it, please read User-defined aggregations - Power BI | Microsoft Learn
As the aggregated table needs to be set up on an Import table, you can bring in a table which has "ID" field from the source database and manage aggregations on it.
Hope my advice would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Thank you. I have tried aggregations, which helps when it is one fact table, but I have 2 large fact tables, and when joined together, causes the error.
I think I will need to go back to the source and extract what I need from there rather than connecting to the live Power BI semantic models.
The 1000000 rows limitation is set to ensure the query performance of DirectQuery. So pre-aggregating data at the data source side will be better when the returned data size is very large in DirectQuery mode.