Automate a calculated column with PowerShell

mm456 — Thu, 09 Mar 2023 23:27:38 GMT

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

Re: Automate a calculated column with PowerShell

lbendlin — Sun, 12 Mar 2023 02:01:40 GMT

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.

topic Re: Automate a calculated column with PowerShell in Developer

Automate a calculated column with PowerShell

Re: Automate a calculated column with PowerShell