Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Power BI Desktop file was working fine yesterday and was able to save it at the end of the day. There were several measures with errors as they were recreated as new ones, but this didn't cause any issues opening the file for several days.
Since this morning however I am getting the error below and cannot open the file:
Feedback Type:
Frown (Error)
Error Message:
<pi>MdxScript(Model) (170, 104) Function 'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column comes from a table on the 1-side of a bi-directional relationship.
I know how to fix the SAMEPERIODLASTYEAR issue, but my issue is that I cannot open the file. The file should still open even if there are errors in some measures.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous ,
When you say you can't open the PBIX file, do you mean that you can't open the report itself or that Power BI Desktop doesn't even start properly?
Have you tried clearing the Power BI Desktop cache and retrying?
1.In Power BI Desktop, Go to File menu and select Options and Settings > Option
2.Click on Data Load Button.
3.Next click on " Clear Cache " button under both " Data Cache Management Options " and " Q&A Cache Options ". Press OK.
4.Once cleared both caches, make sure the "Currently used" value is 0 bytes like the below screenshot.
Best Regards,
Community Support Team _ Caitlyn