topic Re: Disable auto refresh from SQL Server in Developer

Disable auto refresh from SQL Server

Anonymous — Sun, 13 Dec 2020 17:48:28 GMT

I am working with some large queries which uses much capacity so I would like to disable the fact that Power BI automaticly fires every underlying query from our SQL server when I open the program.

Is there a way to turn this off and choose by myself when I want to refresh the data?

Re: Disable auto refresh from SQL Server

kumar27 — Mon, 14 Dec 2020 07:17:13 GMT

Yes, I assume you are using a diret query mode of data connection.

Now, you can change the mode to import and then you can refrsh your data set when you need.

You can change this mode by going to properties on transform data tab , thanks

Re: Disable auto refresh from SQL Server

Anonymous — Mon, 14 Dec 2020 08:16:01 GMT

Thanks for your answer. Unfortunately am I using imported query. I didn't find any information of the query being fired until we checked the capacity directly from our server.

Re: Disable auto refresh from SQL Server

Anonymous — Mon, 14 Dec 2020 09:08:09 GMT

Found this information for using "Import":

When opening an existing report in the Power BI service, or authoring a new report, the imported data is queried again, ensuring interactivity.

(https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about)

I believe this is what I want to disable.

Re: Disable auto refresh from SQL Server

kumar27 — Tue, 15 Dec 2020 10:23:26 GMT

There is an option to turn off the schedued refrsh from the service , by going to workspace and then to datasets and then scheduled refresh