Forum Discussion
How Direct Query Report works
I have direct query report on Power BI service and setup the gateway for it, it works perfectly but one thing I am a little confused is the refresh history table for direct query report (Settin...
I was under the impression that DirectQuery reports don't have scheduled refresh or any kind of refresh at all. What is your underlying data source? The only example I can work off of on my end is Oracle where I don't see anything when going into settings for the dataset.
The DirectQuery report should operate as you mentioned, where any interaction with the report should send a query back to your on premises data source to get the latest information and render the results on the report in the Power BI service. Of course you will need to have set up the on premises data gateway in order for this to work.
