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.
viewing a report is not automatically interacting with the report. Let's assume the user opens the report. At that point the direct query connection refreshes all the visuals in the page that the user is opening per default. Then the user just stares at the screen for an hour, thinking of a nice vacation or a drink. Even if the data source changes the report will not change (unless you have auto page refresh enabled). Only when the user interacts with the report again (switches pages, changes filters etc) will a new batch of direct queries be fired.
thats mean user need to refresh the Report page in order to get the latest visual from data at on premise database. is it?
2 questions:
- How about if gateway is offline?
- What refresh frequency actually did in Parameter settings? (as pictures in 1st post)