cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Les111
Frequent Visitor

Calculation groups with PBIRS

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-... 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

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

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.

d_gosbell_0-1638742644835.png

 

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.

 

View solution in original post

3 REPLIES 3
d_gosbell
Super User
Super User

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.

d_gosbell_0-1638742644835.png

 

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.

 

View solution in original post

Les111
Frequent Visitor

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

Les111
Frequent Visitor

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? 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!