Calculation Group causing report not to load in PBI service (works in Desktop)
Since yesterday 12/15/22, a report that was working for several weeks in Power BI service will no longer render. It continues to work fine and refresh fine in Power BI Desktop. The report shows the following error in PBI Service:
Further, when attempting to connect to the dataset as a data source in a new .pbix file, the following error code was rendered:
After troubleshooting we determined it was the presence of a calculation group in the model that caused the error. When removing the calculation group, the report renders in Power BI Service. When it's added, the error message appears.
Oddly, when viewing in Edit mode, you'll see that the visuals still render (you can see the visual header tooltips) but there are no tables present in the model.
Again, this report works absolutely fine in Power BI desktop. Only an issue when published.
The calculation group has one calc item that is used as a page filter to format some measures based on the format string stored in a column. Removing the page filter, changing the format string DAX logic, modifying the calculation item, etc. does not make any difference. The only way to have the report render is to delete the calculation group entirely.
I also attempted to recreate the model in another report in case the .pbix file was corrupted, and the same error occurred in Power BI service.
Please assist, thank you!
4 Comments
Anonymous Yes I created the calculation group directly in Desktop using Tabular Editor 2 in the External Tools tab (see documentation below, this is the only way to set up calculation groups in Desktop). The solution was working for 8+ months and then recently stopped rendering in Power BI Service.
https://learn.microsoft.com/en-us/training/modules/dax-power-bi-calculation-groups/