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
Icon for Solution Specialist rankSolution Specialist
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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Davis,

     

    As a user I would like to use field parameters to change visuals (dynamically change the measures being analyzed within a report). This feature https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters  is not available in Power BI Report Server. 

    The alternative is to create calculation groups via Tabular Editor. But what if the option for Preview features doesn't exist in the settings of Power BI Report Server?

    Would it alternatively be possible to create a disconnected table and use DAX to display the selected value?  

    Original Post 

     

    Regards

     

    Nici