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.
Hoping if some can tell me if this is the expected behaviour.
The queries setup use the "Today" filter on the date column.
This seems to be the only way to automatically retrieve the data for TODAY, this does not seem possible when done in the report/dash itself.
This "Seems" to be the issue with the data not refreshing correctly
Each morning I have to open the reports in Desktop, refresh and publish. from then on the data is nicely updated via the direct query/gateway throughout the day.
When tomorrow comes, the data set does not update and the reports are stuck on the previous days data until I refresh and re-publish again.
Assuming this is the expected behaviour then how do we set the filter in the reports to only show date from "Today" without having to refilter the data manually, I cant see how.
I would have thought having the filtering done at the query level would have been the more efficient way to do this ?
Hi Steve,
When you use Power BI to filter the imported data source, they apply M like language on that source, for more details, Power BI will apply all the "STEPS" defined in the Power Query Editor each time they refresh the Power BI 's file.
So when you try to apply what you call "filter today" by the interface, they will calculate and save "the today "(ex: 28 july 2016) in your Power BI file and then they only keep "filter on 28 juyl 2016" when the refresh processes.
For the answer, is it possible? Totally yes. and how?
1/ By Power BI main language: DAX. Try yo use "Calculated Measure" or "Calculated Column" by apply the DAX's formula "measure = CALCULATE(yourMeasure; Date = TODAY() )
2/ By Power BI editor : find what happened (technically, not through the interface) when you click on "filter today" in "Advanced Editor" in the "Advanced Tab", it will show you the language M windows (which contains all the code behind the Power BI editor interface)
Have a nice day,