Forum Discussion
Power BI Files Won't Open After February Update
- 1 year ago
Download an older version of Power bi from https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-desktop I downloaded November 2024 Update (link in the botom just before the previous month's header), I had some alert notifications, but file opend, rename the table in it, save the file and go back to the new version.
I had the same problem. My table was named [ Measures ] = BLANK(), but in the January update it doesn't support [ ] table naming, even if I try to name the table that way in the new version, I just can't - 1 year ago
Exact same problem today and took me a while to find an older version of Power BI Desktop to download (odd considering Microsofts recommendations are often to rever back to older versions in the event of a bug). Thanks to the links above I've managed to go back to November and rename my measures table. It was common practice for me to have a table called measures so I have many files affected. It would have been more helpful if we had been able to open the PBIX and then be forced to rename any tables with protected words.
It's a joke that we paying a lot of money and getting these type of bugs every time. Same with Formating percentages.. Microsoft are you even testing your updates?!
This isn't necessarily a bug and is more of a non-conformance to best practices.
"Measures" is a reserved name and cannot be utilised by the user to describe an object. People get around this by using different names such as " Measures", ".Measures". The primary reason people use this naming convention is because it puts the measures object at the top of the view pane on the right hand side.
Microsoft has already resolved this by designing a measures-specific object to appear at the top of the viewing pane.
The documentation uses the naming convention 'Calculations' which can be seen in their image under the section titled Organising your measures (the final text piece above the green tip):
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-measures