I have created a report in PowerBI Desktop that uses direct query to connect to an Azure SQL Database.
I have then published this to the powerbi service, gone to the dataset and entered the credentials for that sql database.
However, when i update data in the azure sql database it doesn't show on the report online unless I do a manual refresh.
My understanding was direct query goes directly to the database for data. Am i missing something?
@brentphillips when you update data in the table in azure sql db (and no interaction on power bi dashboard) then dashboard tiles will be updated automatically approx every 15 minutes. however if you click on slicer or do some filtering for that tile then query will be sent back to azure sql db and you will see the updated data on the tile.
This is to do with reports. Even after waiting overnight and filtering data it still doesn't direct query data. I have to do a manual refresh to update the data.
Have you tried to user fiddler to capture a network trace？
From the trace we could be able to check the query details when interact with Visuals in the reports.
I will try to set up some tests on this, there might be some time delay before I could share any results here.