Forum Discussion

Johan's avatar
Johan
Advocate II
8 years ago
Solved

Reference query accesses the source twice

Hi,

 

When I user 'reference' in the query editor, it should load from the initial (referenced) query. But PBI seems to access the source database again.

 

How can I load from the previously loaded table, instead of having to access the source again?

 

Thanks,

Johan

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Johan,

    What database do you use? I get data from SQL Server database, I can reproduce your scenario, reference still access database again, which is designed by Power BI.

    Please add Table.Buffer in your original Query, when you refresh your reference, which wouldn't access the database again based on my test. 



    And there is a similar thread for reference.

    Best Regards,
    Angelia

3 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Johan,

    What database do you use? I get data from SQL Server database, I can reproduce your scenario, reference still access database again, which is designed by Power BI.

    Please add Table.Buffer in your original Query, when you refresh your reference, which wouldn't access the database again based on my test. 



    And there is a similar thread for reference.

    Best Regards,
    Angelia

    • Johan's avatar
      Johan
      Advocate II
      8 years ago

      Thanks for you help.

      The thread you were referring to describes it well. Apparantly it depends on the caching of the initial query. 

      I think the table.buffer (or list.buffer) only works within 1 query.

  • Mikey2020's avatar
    Mikey2020
    Frequent Visitor
    1 year ago

    I am connecting to Oracle Database; facing same issue. Reference refreshes twice instead of pulling the data from main table. Defeats the purpose of reference .

    Anyone done in Oracle like for SQLServer?

    Any leads is appreciated.