Forum Discussion
kevhav
Continued Contributor
Continued ContributorWhy does a reference query pull from the DB?
I am using the Query Editor in Power BI Desktop, with a file in "Import" mode. I have a query "Foo", the first step of which is to pull data from a SQL Server database (= Sql.Database("SERVER", "...
Please Check out this Article from Chris Webb's BI Blog. You can understand the logic behind this.
https://blog.crossjoin.co.uk/2016/11/20/referenced-queries-and-caching-in-power-bi-and-power-query/
BhaveshPatel
Super User
Super User
Please Check out this Article from Chris Webb's BI Blog. You can understand the logic behind this.
https://blog.crossjoin.co.uk/2016/11/20/referenced-queries-and-caching-in-power-bi-and-power-query/