Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @wicket250
What is your data source ? If you add the calculation group in Desktop not in your data source , can you laod your data in Power BI Service ?
Best Regards,
Community Support Team _ Ailsa Tao