Forum Discussion

Les111's avatar
Les111
Resolver I
4 years ago
Solved

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/t...
calculation groups
PBIRS on premise
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    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.

     

d_gosbell's avatar
d_gosbell
Super User
4 years ago

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.

 

  • Les111's avatar
    Les111
    Resolver I
    4 years ago

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