Forum Discussion
Data doesn't get updated by direct query report
I have a report, data connection type is mixed(all tables is direct query except I create a data table by using DAX). Data is from my Azure SQL Database. After I finished it, I published it to my public workspace. However, this report doesn't get any data updated since I published it. I tried to interacte the report. It doesn't update my data on the report. Now I have to set a schedule refresh on that dataset(which suppose to use for refreshing Import mode report). Can anyone tell me how to get my data refreshed?
11 Replies
- GilbertQ
Super User
Hi there
Can you confirm that your table from Azure SQL Database is in DirectQuery?
You can click on the table in Power BI Desktop, then right click and select Properties.
What does the storage mode say? - GilbertQAlso remember that you have to interact with a report for the data to be refreshed.
or you have to press the refresh button.
Whilst there is a new feature for the reports to auto refresh if you are using Power BI Pro it only updates every 30 minutes.GilbertQ Does data get update if I click the refresh button on the report? I thought the 'refresh' button on the report only refresh the visualation on the report which doesn't refresh my data. Anyway it works. Thanks for the advise. However when I interact with my report, my data doesn't get updated. Why this? Or which kind of interaction can refresh my data in this case?
venal I am not sure what you are saying. I don't use any gateway because my data is from an Azure SQL database. Why do I need a On-Pre gateway to config my cluster? See this document from MSDN.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
