Visual calculations on PowerBI Report Server

[Mous]

Hello,

I have a report with 2 tables. The 2nd table contains visual calculation (I'm computing a % delta with previous line

( ([qty] - (PREVIOUS([qty]))) / PREVIOUS([qty]))*100 and in PowerBI Desktop all works as expected. I've tried to load it on my Power BI Report Server, but there only the 1st table loads correctly. The 2nd fails with following error message :

The query contains unsupported visual calculation expressions. Either the model capabilities do not support visual calculations or the visual calculation feature switch is off.

PowerBI Desktop : 2.138.1452.0 64-bit (novembre 2024)

PowerBI Report Server : Version1.22.9153.7886(Janvier 2025)

Any idea on this issue?

Thank you

[v-jtian-msft · Accepted solution]

Hi,@Mous .I am glad to help you.
Visual calculations is a Preview feature. power BI Report Server, as a local report server, supports a very limited set of features compared to Power BI Service and does not support the features that are currently in the Preview state.
You can try to republish the report to Power BI Service instead of Power BI Report Server.

Solved: Preview Features not showing in the options menu (... - Microsoft Fabric Community

Solved: Re: Export entire report to pdf in Power BI Report... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mous]

It seems that it is a limitation on PBIRS which is sad as the reports can't be deployed on server.