Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Query Loading Order

How does Power BI determines the order of queries loaded in the data model? Is it determined by the order of sources you get?
General Comment
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    It looks like nothing special loading queries. The queries can be loaded concurrently.

    Query_Loading_Order

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

It looks like nothing special loading queries. The queries can be loaded concurrently.

Query_Loading_Order

 

Best Regards,

Dale

AdrienneB's avatar
AdrienneB
Frequent Visitor
3 years ago

Hi v-jiascu-msft , queries that have a dependency on each other cannot be loaded concurrently. For example, limiting the date table based on max date in the FACT table cannot load concurrently. It even throws an error sometimes about it but no consistently. 

The error wording is: Query 'Query Name' (step 'Step Name') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

 

Again, this is inconsistently coming up in PBI desktop.