Forum Discussion
direct query data refresh
Hi, space83
It’s my pleasure to answer for you.
According to your description,you used DQ mode to connect the datasource.In this way, the data refresh type is schedule cache refresh.You should know that when you first open the report or interact with the report, you will get the latest data from the data source if you use DQ mode regardless of setting data refresh.This is the benefit of DQ.
You can use schedule cache refresh to speed up the refresh frequency of tile cache(default is one hour in dashboard).
If you use standard gateway,it will run as service even without logging in again ,unless you stop it or shut down computer.
You can parameterize the data source in PQ, then change the parameters in the service, change the data source path, or use the parameter filter rows and replace values.
link:https://docs.microsoft.com/en-us/power-bi/connect-data/service-parameters
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, space83
It’s my pleasure to answer for you.
According to your description,you used DQ mode to connect the datasource.In this way, the data refresh type is schedule cache refresh.You should know that when you first open the report or interact with the report, you will get the latest data from the data source if you use DQ mode regardless of setting data refresh.This is the benefit of DQ.
You can use schedule cache refresh to speed up the refresh frequency of tile cache(default is one hour in dashboard).
If you use standard gateway,it will run as service even without logging in again ,unless you stop it or shut down computer.
You can parameterize the data source in PQ, then change the parameters in the service, change the data source path, or use the parameter filter rows and replace values.
link:https://docs.microsoft.com/en-us/power-bi/connect-data/service-parameters
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have created a test reporting using SQL data under direct query mode. Here is my observation:
when I open the pbix online file, the data didn't get refreshed automatically. If I edit the file or click into a visual, indeed the file gets updated. But the update is not saved, which means, when I exit and reopen the online file, I see see old data.
I think there are two ways to keep data updated:
1. open the file online, and click refresh button in the explorer browser, or
2. create scheduled data refreshment via gateway
Jeanxyz If you use dq mode, when you open the report in service, It will perform a query to get the latest data. When you interact with the report, the query will also be sent. And don’t need to save. DQ refresh refresh the cache. It is only possible that the original data has changed after you open the report, and the data has not been refreshed in time due to the browser’s cache settings.
Secondly, there is no pbix file in the service, it will be divided into two parts, report and dateset.
Best Regards
Janey Guo
