Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This is pretty weird. I have created set of dashboards in my desktop PowerBI about half a year ago. It's build on pretty simple data model (2 Fact tables and 4 Dimension). It takes data from sql server db and I updated it once in a while manually with the Refresh button (Last time I updated it a few months ago). All the visualizations worked perfectly fine after the refresh.
Today I decided to delete old data (old season) from DB and load new ones (new season). Then I refreshed it and I expected that it will work the same way. But after the refresh all my visualizations stopped working it says just "blank" in all the visualizations.
I did not change the structure of any tables and tables contain data. In "data" card I can clearly see that both fact tables contain values with no errors but when I try to create a new visualization/table with columns only from the Fact table, it won't show any data, just headers. That is not case for dimensions as visualization with just dimension is showing data. I tried to create new visualizations in new project (pbix) with same Fact tables and it works great. So the problem is not in those tables, they have completely same structure as before and also contain data. Also, the problem is not in relationships. I tried to delete those fact tables and reload them. It Also didn't work.
Please help me, I dont want to recreate all those dashboards, it would take a lot of time.
Solved! Go to Solution.
Did you define any Page or Report filters?
Did you define any Page or Report filters?
Oh yeah I had Report level filter set until summer 2018. Such a dumb mistake. Thanks a lot!
No worries, that's what the forums are here for, sometimes just needs another set of "eyes"!
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |