Forum Discussion
Data doesn't get updated by direct query report
I have a report, data connection type is mixed(all tables is direct query except I create a data table by using DAX). Data is from my Azure SQL Database. After I finished it, I published it to my pub...
GilbertQ
Super User
Super UserHI there
Can you confirm that there is data being updated in the underlying Azure SQL DB?
Also are there any filters on your page or visuals which could be limiting the data from being updated?
Can you confirm that there is data being updated in the underlying Azure SQL DB?
Also are there any filters on your page or visuals which could be limiting the data from being updated?
GilbertQ Thanks for reply. I do confirmed that underlying data in my Azure SQL DB is updated.(we use a sync-group to synconaized data from local SQL DB to Azure SQL DB). I check the log from Sync-group. My data is successfully updated every time. Secondly, There only a date filter that filtered my visualazition. That is used for filter out our today data. I don't think any of these factors caused my data not being freshed on the report.