Forum Discussion
SQL 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.
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.
wonga Thanks for your reply. My question is answered now. I wil use a plugin in my browser to refresh the report/dashboard. Unfortunally it is not possible (at te moment) to schedule the refresh on the gateway (like using the Import option).
- Bas: Hi, could you please tell me what is your process of using the plugin from website ?:
1/ the name of your plug-in
2/ you refresh the report page or the dash board page? By refreshing the web page (f5) or click on the refresh button of dashboard/report
3/ and any other points that you think thus is important to know before implementing the solution.
thanks very much,
DANHi DAN,
I am using Google Chrome as browser. I installed the plugin Revolver Tabs (https://chrome.google.com/webstore/detail/revolver-tabs/dlknooajieciikpedpldejhhijacnbda)
This plug-in is automatically scroling through the different tabs opened in Google Chrome. Every tab is showing a page of my report. Before opening the next tab in Google Chrome, the plug-in automatically refreshes the page. This ensures the recent most recent data is showed.I hope that this (https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10861638-slideshow-in-full-screen-tv-mode) idea will be launched soon. Because our reports are showed on a big screen.
Does this answer your question?
- Hi Bas,
Ill implement your solution right now and ill keep in touch with you for the result.
Thank you very much :)
Have a nice day,
DAN
