Forum Discussion
Power BI "Event ID 22 from source MSOLAP$AnalysisServicesWorkspace cannot be found" error
Hi, I have a similar problem and I know how to reproduce it:
Create a new report
Add a DimDate table using:
DimDate = CALENDAR( DATE(2024, 1, 1), TODAY() )
3. Add a slicer using the Date column from DimDate
4. Create a measure
CurrentDate = MAX(DimDate[Date])
5. Add a card visual showing the CurrentDate measure
At first, everything works perfectly.
If I adjust the upper bound of the slicer, the card updates correctly.
But when I adjust the lower bound of the slicer (to move the start date forward), the card breaks and gives the "See details" error: "Error fetching data for this visual" "An unexpected error occurred (file '', line , function '')"
Now, if I change the measure to:
CurrentDate = MAX(DimDate[Date].[Date])
it works again, even with the lower bound adjusted.
Why would simply adjusting the lower bound of the slicer cause this issue? And why does adding `.[Date]` magically fix it?
The weirdest part is that this was working fine two weeks ago (same laptop).
I'm not sure if it's relevant, but I'm running Power BI on Parallels on an M1 MacBook.
AdministratorFrom today the exact same thing happens to me, so some WINDOWS update is causing the failure. I also have Paralles on a MacBook M3, and 2 days ago this worked perfectly with the same file. I've restarted, reinstalled POWER BI DESKTOP, and nothing. If the same thing happens to you and you have found the solution, let it indicate. The error you see in the event viewer is this same -->
... event id 22 of the origen MSOLAP$AnalysisServicesWorkspace...
I created a new issue: https://community.fabric.microsoft.com/t5/Desktop/Weird-behavior-with-date-slicer-and-MAX-measure-on-DimDate/m-p/4644679#M1389243
jemgrant73 mentioned in the issue that this happened to him while working with Windows, so it's not exclusively related to Parallel