Forum Discussion

NehaSingh's avatar
NehaSingh
Regular Visitor
9 years ago
Solved

Data does not get refreshed with Direct Query.

I have used Direct query for some reports. But data of that report does not get refreshed with the database. To refresh that data I need to open the report locally, refresh and republish. Why it is...
Dashboards
Reports
  • NehaSingh's avatar
    NehaSingh
    9 years ago

    Yes, I finally got the solution.

    I unpinned the report from dashboard, deleted the report, republished it.

    This worked for me.

     

daver1117's avatar
daver1117
Frequent Visitor
8 years ago

I am also having problems with Direct query. I have a SQL server on prem database and an On prem Gateway configured. I was able to create the report needed using Direct Query in Power Bi Desktop. I deployed the report to my online powerbi, pinned it to a dashboard and modified the Scheduled cache refresh settings on my dataset to every 15 minutes. The Refresh history shows that the data refresh is happening every 15 minutes with no errors, yet my report will not change results, even though the underlying database views are changing. I can get the results to update if I refresh my browser, or manually click the refresh database tile option in the service. I want to see that this dashboard will refresh on its own, so I can look to publish to wallboards around our office.