Forum Discussion
Advocate IISQL On-Prem with Enterprise Gateway refresh issue
As ankitpatira mentioned, because your dataset uses DirectQuery, the only time data on a dashboard and/or report will change is when it is accessed and a query is sent to your on-premises data sources through the enterprise gateway.
It sounds like your question is referring to having a dashboard showing at all times and seeing real-time changes as either new data or pre-existing data changes. This is not possible unless a query is being sent from the Power BI Service to your on-premises data source through a gateway.
In your example, clicking the "refresh" button is equivalent to sending a query(s).
You can either click the refresh button or possibly set your dashboard webpage to refresh on a certain interval through your web browser in some way.
Hope this helps clarify things.
Advocate IIHi Bas,
Thanks for your active.
I hope so..
I installed the gateway of another machine of the server (who can communicate with the server ofcourse).
I configured datasource.
=> I passed this 2 points very easy. What's your problems?
DAN
Hi, same isue, or perhaps confused over the expectation of how this would work.
Gateway installed and working
Direct queries to SQl setup and working
Withn Power BI Desktop I have Date filters on the data that is retrieved
I can view the reports via the office 365/bi interface BUT it never updates
The only way I can get the data to update is to open in Desktop, "Refresh" and then publish again.
The Datasource names etc are the same as per the instructions .
My expectation is that i wont need to do anything and the reports via the Web interface will be updated from the SQL source data automatically