Forum Discussion
How to derive static tables from PowerBI queries without data connection
Hi Anonymous
That is correct that this will happen when you are working in power. Bi desktop, but once you upload it to the service, you should no longer see in your requests coming through because it is now a static table.
Hi there GilbertQ
The problem is - as soon as i close the PowerBI query editor with "close and apply", PowerBI makes a report refresh for all tables, which got the attribute "enable to load", although "include in report refresh" is deactivated for them.
That leads to ~400 billable transactions for every "close and apply", which is necessary from time to time, if i want to use these tables directly in visuals.
So i basically tried to make a copy of these tables (7 values test-table), which are referencing the columns of the (live-data) table. Deactivated both "enable to load" & "include in report refresh" for the live-data tables and only enable "enable to load" for the referencing ones (and deactivate "include in ...")
-> That also leads to billable transactions in my Azure Maps instance, for both cases.
This setting also made no difference in that behaviour: