Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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
Greg_Deckler
Super User
Super User

Did you define any Page or Report filters?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

Did you define any Page or Report filters?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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"!


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.