Forum Discussion

Vallirajap's avatar
Vallirajap
Icon for Resolver III rankResolver III
2 years ago
Solved

Split Query difference in PowerBI

Hi All, Recently, I faced one issue when I had one query that contained the maximum amount of data in a PowerBI report. It reduced the performance.   So I decided to split the query, load all the ...
Data Protection
General Comment
Need Help
Show and Tell
  • Arul's avatar
    Arul
    2 years ago

    Vallirajap ,

    When you split the query and load all related tables separately, Power BI creates a data model that includes all the tables and their relationships. If your original query contained many related tables and relationships, loading them separately might result in a larger data model due to the duplication of metadata, indexes, and other internal structures required to manage relationships.

Arul's avatar
Arul
Icon for Super User rankSuper User
2 years ago

Vallirajap ,

When you split the query and load all related tables separately, Power BI creates a data model that includes all the tables and their relationships. If your original query contained many related tables and relationships, loading them separately might result in a larger data model due to the duplication of metadata, indexes, and other internal structures required to manage relationships.