cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GautamW New Member
New Member

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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!


1 REPLY 1
Super User
Super User

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!