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.
Bas If you've connected to on-prem sql server using DirectQuery then you don't need to worry about data refresh as data is not stored in power bi. With DirectQuery you are connecting live to sql server. Everytime you access the report queries are sent to on-prem sql server and data is returned back for those queries.
What makes you say that data is not refreshed automatically ? You also don't need to worry about clicking Refresh button as it is live connection.
ankitpatira Thanks for your reply. I understand that the data is automatically refreshed with DirectQuery. But my question is: Is it possible to refresh the data without clicking the refresh button on the ribbon?
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,
DAN
Bas Direct Query implies "automatic", but it isn't really like that unless you are actively using the reports. For display purposes, if you are showing your dashboard on large screen the tiles should be refreshed every 15-30 minutes, although I've seen a great number of threads that say it can take longer... depends.
Is there a way to "schedule" the refresh of tiles? "No"
Hopefully that answers the question, but throwing out "automatic" and "refresh schedule" in the same sentence is confusing as the two don't really have anything in common when talking about this connection type.
