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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Nick,

     

    But what if i wanted to set an order? :smileysurprised:

    • JasonC_XBI's avatar
      JasonC_XBI
      Icon for Advocate II rankAdvocate II
      5 years ago

      I was thinking the exact same thing.
      I have a model that has evolved over time.  It now takes about 10min to load all the data.
      One of the tables is a single row, Last Refresh table, that reports on the currency of the data.
      Being small, this table is always one of the first to load, and that means the Last Refresh time stamp is always a little bit out.
      It's not a big issue, but it would be nice if there was some way to flag that this table should load last.

      • EnglishCJ's avatar
        EnglishCJ
        Frequent Visitor
        5 years ago

        In the following video there is a possible solution:
        https://www.youtube.com/watch?v=YfdypVSYb9c
        After disabiling the concurrent refresh ([!] I have not tested the effect upon performance of doing this), next you can add an M Code function function.InvokeAfter in the advanced editor.

        I think that you could set it up where the function that is called "daisy chains" through the load order you're interested in.

         

        However there's probably a more elegant solution. If I find it, then I'll check back... because I'd like to add a table for load duration, in addition to the load time through

         

        datetime.localnow

        or, in my case, the pl/SQL:

        Select

        TO_CHAR(SYSDATE, 'DDMONYYYY HH24:MI:SS') "Retrieved"

        From

        Dual

  • Netrelemo's avatar
    Netrelemo
    Icon for Helper IV rankHelper IV
    6 years ago

    Well that maybe, but that doesn't answer the question. Why this is marked as the solution baffles me. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Netrelemo , I notice a lot of 'solutions' like this. A question is posted "How do I do this?" and someone replies "You can't" and the reply is marked as a soluton 🙄

  • 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.