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.

     

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

NehaSingh

 

What is your data source here? Please note that if the data source used does not need the On-Premises Data Gateway (Azure SQL Database, Azure SQL Data Warehouse, or Redshift), credentials must be provided before the published report will be displayed in the Power BI Service.

For data sources other than Azure SQL Database, Azure SQL Data Warehouse and Redshiftthat use DirectQuery, an On-Premises Data Gateway must be installed and the data source must be registered to establish a data connection. You can learn more about On-Premises Data Gateway.

 

Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/#publish-to-the-power-bi-service

 

Best Regards,
Herbert