I have 2 Azure SQL based reports that utilizes DirectQuery mode. Report are pretty similar business-wise, datamodel-wise. One is little bit more extended for premium clients. One of them is not behaving on powerBI service and embedded as expected. For the sake of discussion lets call working one: X and not working one: Y.
Introduction:
It is 6th December 2021 and I applied some changes in powerBI Desktop to both, Z and Y reports. I also hit refresh button. I save and upload it to powerBI service. Both dashboard display last observations and its date and I can see that both of them are showing latest data correctly (which is 6th Dec). After few days I get report from client that report Y was not refreshed.
- > I check in client embedded app - it is not refreshed (it looks like snapshot from 6th Dec).
- > I check in powerBI service - it is not refreshed (it looks like snapshot from 6th Dec).
- > I check the data in SQL tables - it IS refreshed there.
- > I check on my desktop version - it IS refreshed there.
OK, thats weird.
- >I reupload Y report from my dekstop (which is displaying fresh data correctly) without hitting refresh button.
- > It is refreshed on powerBI service.
- > I hit refresh visuals button on the report page.
- > It comes back to snapshot from 6th Dec!!!
Im confused.
- > I hit refresh now button in powerBI service to refresh dataset.
- > I hit refresh visuals button.
- > It IS refreshed as expected.
-> Issue happens again next day...
On top of that, report X is working as expected. There is direct connection to database and it shows latest data on the report. No hitting refresh now button required! I compared ALL (by all I really mean every possible) setting of the:
-dataset on powerBI service
-report on powerBI service
-desktop file
and they are exactly the same for X and Y reports.
Might be worth mentioning:
1) report Y once a POC, was based on parquet files and the migrated to Azure SQL tables. Without deleting visuals, just replacing data sources (maybe some caching mechanism?).
2) both reports uses bookmarks for some predefined date filtering.
Any idea what might be the reason? There MUST be something wrong somewhere, as both reports are really similar, using same database, similar data, same bookmarks type. Last thing that probably WILL help is to drop report Y all together and recreate it, but I would rather avoid that.
Thanks in advance.
