Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create Calculation Group in Power BI Report Server

Hi everyone~   We can create calculation group on standard version of Power BI Desktop by using external tool like Tabular editor, how can we achieve this in on-premise Power BI Report Server? Is ...
Help with DAX
Report Server + PBI On Permises
  • DavisBI's avatar
    DavisBI
    5 years ago

    Hi, Anonymous 

     

    That's possible if you using the latest version of PBIRS (2020-Oct) or the later versions.

    The PBIRS does not support external tool yet but you can enable "enhanced metadata format" at "preview features" so that you can use tools like "tabular editor" to create the calculation group on PBID (RS version)

    Best.

     

    Mark this post as solution if this helps, thanks!

  • johncpratt's avatar
    johncpratt
    3 years ago

    I just installed Tabular Editor 2.17.2 to investigate creating calculation groups.  I am primarily using PBIRS for my report development (currently May 2022 GA, about to upgrade to Sept 2022 GA).  I searched and searched for exact directions on how to actually connect to a PBIX data model for a PBIRS report with no luck, and finally just started clicking stuff in Tabular Editor.  After a few tries, I found it! (hint:  Power BI Desktop starts a local instance of SSAS)

     

    First, open the PBIX you want to modify in Power BI Desktop.  Then open Tabular Editor (you can open TE first, but you need the PBIX open to get this to work).

     

    In Tabular Editor, select File > Open > From DB.  You will get the dialog show below.  All you need to do is use the "Local instance" dropdown to select the PBIX you have opened, which is effectively running its own local server instance of SSAS.

     

     

technolog's avatar
technolog
Super User
4 years ago

Could someone provide screenshots of working PBIRS with Tabular Editor?

johncpratt's avatar
johncpratt
Advocate III
3 years ago

I just installed Tabular Editor 2.17.2 to investigate creating calculation groups.  I am primarily using PBIRS for my report development (currently May 2022 GA, about to upgrade to Sept 2022 GA).  I searched and searched for exact directions on how to actually connect to a PBIX data model for a PBIRS report with no luck, and finally just started clicking stuff in Tabular Editor.  After a few tries, I found it! (hint:  Power BI Desktop starts a local instance of SSAS)

 

First, open the PBIX you want to modify in Power BI Desktop.  Then open Tabular Editor (you can open TE first, but you need the PBIX open to get this to work).

 

In Tabular Editor, select File > Open > From DB.  You will get the dialog show below.  All you need to do is use the "Local instance" dropdown to select the PBIX you have opened, which is effectively running its own local server instance of SSAS.