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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
KremenaK
Frequent Visitor

Error message preventing Power BI desktop file to open to fix the error (about wrong DAX formula)

My pbix report cannot open any more – when I last opened (last week) it worked fine, and yesterday on my attempt to open it came back with the following error message below without an option for me to go in, troubleshoot and fix the problem with my DAX formula (FLOOR).

KremenaK_0-1667376557517.jpeg

I found what the issue is, working with an older pbix file last saved in September. Based on the current data, the 2 arguments of the FLOOR function become numbers with opposite signs, which errors out.

But how do I fix it in my most recent report if it’s not opening?

I’ve had similar error messages in the past, but Power BI has allowed me to go in the file and do the fixes.

Appreciate your help!

1 ACCEPTED SOLUTION
KremenaK
Frequent Visitor

A day later I was able to reopen the pbix file which produced the error message, fixed the code and it runs well now. I guess something had stuck in the buffer which was preventing from opening. I hope to never run into this issue again...

View solution in original post

3 REPLIES 3
KremenaK
Frequent Visitor

A day later I was able to reopen the pbix file which produced the error message, fixed the code and it runs well now. I guess something had stuck in the buffer which was preventing from opening. I hope to never run into this issue again...

KremenaK
Frequent Visitor

Unfortunately downloading a higher version is not as easy - needs to go to firmwide approval an testing which may take days, if not weeks.
I have asked the data source admin to make a change to the underlying data - it solved the problem when tested on another computer (with the same Power BI version as mine), but it still does not open the file on mine. Cleared the (PBI) cache, still No. Any other suggestions?

amitchandak
Super User
Super User

@KremenaK , Please download and install Sep-2022 version and try again

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

 

If needed, log an issue too : https://community.powerbi.com/t5/Issues/idb-p/Issues

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors