DirectQuery mode PowerBI not refreshing data from AzureSQL

[Anonymous]

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.

[Greg_Deckler · Accepted solution]

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.