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

[KremenaK]

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).

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!

[KremenaK · Accepted solution]

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]

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]

@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