Forum Discussion
Dataset refresh issue in PowerBI Service using direct query
Hi Anonymous ,
First of all, we suggest you to remove the email information in your screenshot.
Based on this document: https://docs.microsoft.com/en-us/power-bi/refresh-data#understanding-data-refresh
Power BI does not import data over connections that operate in DirectQuery mode. Instead, the dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. Power BI transforms and forwards the queries to the data source.
Because Power BI does not import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes, as the next section on refresh types explains. A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results.
So If you are using the DirectQuery Mode, the report should query data source to get the newest data when you access the report or refresh the report, but the title you pin to the dashboard will be affcted by the "Scheduled Cache Refresh".
Can you access the report when use the Direct Query? Does the data change when you refresh the report page after data source changed?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
thanks for the tip to remove my email-address, which I did now:)
We don't have a dashboard but a report setup, and the report uses various visuals. If hit the refresh button in the desktop-version, than it refreshes properly and I see the correct data from our on-premise SQL Server.
But in the published report to the web, at renewed opening OR even if I hit the refresh-button at the top of the report-page, nothing changes. So anybody who doesn't use the desktop-version, but consumes the data from the published report doesn't see the updated data.
The problem is really in the refresh of the published online-version, and that one is used by almost everybody oin the organisation. But if that doesn't refresh the data, there is no point in using the report.
Any idea if I am doing something worng? I am almost at the point that I am going to re-write the entire report (multiple pages, multiple visuals etc) which would take me a lot of time. I would like to understand if I am doing something wromng or if there is a seeting that I need to set in order to get the latest data from our on-premise SQL server (that is being refreshed twice per day) in the published online report.
Any help would be super helpfull.
Regards,
Norman
Norman,
long shot, but is there a Power BI gateway entry for the datasource?
Did this help you or did I answer your question?
Then please give kudos or mark my post as a solution!
My blog: nickyvv.comHi Nicky,
yes see my initial entry in this question, there is a picture of the gateway setup between the datasource and the SQL Server DB.
So yes there is....
