Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |