Reply
Highlighted
New Member
Posts: 1
Registered: ‎01-26-2019
Accepted Solution

DirectQuery mode PowerBI not refreshing data from AzureSQL

Hi,

 

Posted a Power BI report to Portal in DirectQuery mode connecting to an Azure SQL DB. The Portal shows that the Connection is correctly set to DirectQuery - however, we are having issues with the Data refresh. When "Refresh Now" is clicked it says Completed in Refresh history - but the data doesn't change. Similarly, don't see any update after setting the Refresh Cache to 15 minutes.

 

Is there any other setting that's required?

 

thanks.


Accepted Solutions
Super User
Posts: 10,462
Registered: ‎07-11-2015

Re: DirectQuery mode PowerBI not refreshing data from AzureSQL

If it is setup for DirectQuery, the data should refresh as you interact with the report, so if you select a slicer, it is sending a query to the data source for example.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


View solution in original post


All Replies
Super User
Posts: 10,462
Registered: ‎07-11-2015

Re: DirectQuery mode PowerBI not refreshing data from AzureSQL

If it is setup for DirectQuery, the data should refresh as you interact with the report, so if you select a slicer, it is sending a query to the data source for example.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!