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.
Super UserHi 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.
Problem for that case is - i can´t deploy this version of the .pbix, because the query script contains the Azure maps primary key. I would need to delete the key before uploading it to the web environment (for security reasons), which usually breaks the data model.
Maybe it can be an approach if i replace the primary key with an azure key vault secret.