Automate a calculated column with PowerShell

[mm456]

Hi all,

I'm trying to automate a PowerBi report that I have published that uses parameters to change the values for data coming from AzureBlobs.  I have one report and I'm using powershell to deploy changes to various workspaces such as changing the title of the report. However, I have a calculated called Area (below) that checks for specific strings in another column and renames them.

Area = SWITCH (

    TRUE(),

    CONTAINSSTRING(Data[Service],"Dev"),"Test",

    CONTAINSSTRING(Data[Service],"demo"),"Demo",

     "Other"

    )

Since, I'm using multiple datasources and expect this column to change from time to time with different values thus the calculation must be done on the fly. How can I calcucate this field either using PowerShell or within PowerBI or any other suggestions?

Thanks,

Marl

[lbendlin]

That's more something you would do with ALM Toolkit or Tabular Editor. You can ask them to script the action and then "borrow"  the XMLA and reuse it in your Powershell scripts.