Change filter in report/pbix file with API

[Benito_BI]

Hi,

I'm trying to find out if its possible to change a report filter with the API or another tool.

What i'm doing is i created a pbix file and publish this to a workspace. In this pbix i have a filter set like example a filter on the date column.

Now through the API i can copy the pbix file and push this to another workspace.

But when its doing this i would like to change a filter in this pbix file.

Is something like this possbile?

Kind regards,

Benito2313

[lbendlin]

Cute. Keep in mind that the structure of the pbix and obit changes over time with changes to the semantics. Be prepared to modify your code on these occasions.

[Benito_BI · Accepted solution]

I have found a way, its not pretty but i think it works. The only thing i need to do is to create a PowerShell script that automates everything.

https://community.powerbi.com/t5/Desktop/Modifying-the-Layout-file-that-is-embedded-in-a-pbix-file/t...

[lbendlin]

You can add report level filters to the URL of the newly created report. That will override the defaults from the original report but it will still give the end users the option to modify the filter. 

As far as I know you cannot yet programmatically change the report design.