topic Re: Calculation groups with PBIRS in Report Server

Calculation groups with PBIRS

Les111 — Thu, 02 Dec 2021 22:00:11 GMT

I understand it may be possible to create calculation groups in PBIRS reports but can't find how you can connect to the data model from Tabular Editor.

This thread https://community.powerbi.com/t5/Report-Server/Create-Calculation-Group-in-Power-BI-Report-Server/m-p/1494565 says you can do it by enabling enhanced metadata format, which was a preview feature some time ago but I can not see any option for now int he Sept 2021 desktop client.

Is it possible to create calculation groups for PBIRS, and if so how?

Thanks

Leslie

Re: Calculation groups with PBIRS

Les111 — Sun, 05 Dec 2021 21:55:46 GMT

So I found you can open the .pbix file in power bi desktop (RS edition) then save it as a power bi template .pbit file. Then you can open the .pbit file in Tabular Editor and create calculation groups or whatever. Then open the .pbit file in power bi desktop and save it as a .pbix file. That's all I've managed to do so far, but if anyone has any more details it would be useful, e.g. I know the external tools menu is not available in the report server edition of desktop, so Tabular editor can't be opened directly from desktop, but are there any limitations to using tabular editor with PBIRS compared to the PBI Service?

Re: Calculation groups with PBIRS

d_gosbell — Sun, 05 Dec 2021 22:26:31 GMT

I think the new metadata format may be the default in the Sep 21 release. Have you tried just open the model in Power BI Desktop, then open Tabular Editor and choose the option to connect to a DB. Then choose the "Local Instance" option and you should see your file listed in the drop down.

If that opens without the warning about needing the v3 metadata you should be able to add your calculation group just as you would if you had launched from the external tools.

Re: Calculation groups with PBIRS

Les111 — Sun, 05 Dec 2021 23:21:42 GMT

That's excellent. Thanks d_gosbel this makes it much easier.