cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Visualizations don't work after updating Fact tables

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Visualizations don't work after updating Fact tables

Did you define any Page or Report filters?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Visualizations don't work after updating Fact tables

Did you define any Page or Report filters?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
New Member

Re: Visualizations don't work after updating Fact tables

Oh yeah I had Report level filter set until summer 2018. Such a dumb mistake. Thanks a lot!

Highlighted
Super User IV
Super User IV

Re: Visualizations don't work after updating Fact tables

No worries, that's what the forums are here for, sometimes just needs another set of "eyes"!


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors