cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Johan Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-huizhn-msft Super Contributor
Super Contributor

Re: Reference query accesses the source twice

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. 

1.PNG

And there is a similar thread for reference.

Best Regards,
Angelia

2 REPLIES 2
Highlighted
v-huizhn-msft Super Contributor
Super Contributor

Re: Reference query accesses the source twice

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. 

1.PNG

And there is a similar thread for reference.

Best Regards,
Angelia

Johan Regular Visitor
Regular Visitor

Re: Reference query accesses the source twice

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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 154 members 1,937 guests
Please welcome our newest community members: