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.
Direct Query means that any user interaction (clicking on a report visual, changing a filter etc) will result in a new query against the data source. Dashboards are not interactive, therefore you need to decide when to refresh the tiles, even with Direct Query .
