power bi + power automate > expression contains ?

[Anonymous]

Hello,

I want to automate a powerBI report generation in PDF via power automate.
And I would like to add a filter in power automate.
Can you tell me how to configure the "ReportLevel Filters Filter-1" field please ? 

Thank you

Pauline

[Anonymous]

Hello,
Sorry I was away for a while!
Unfortunately I can't test your solution because to do what I want, I need a premium license and I don't have it ...
Thank you for your feedback anyway, it will certainly help another person!

Pauline

[selimovd · Accepted solution]

Hello @Anonymous ,

yes, they have to have the format like described in the documentary.

So the easiest version would be:

myTable/myColumn eq 'value'

If you have multiple values you can use:

myTable/myColumn in ('value1', 'value1') 

You can also test that in the browser. Open the report and add after the URL:

?filter=myTable/myColumn eq 'value'

If the URL already has a question mark you can add the filter with a "&" sign:

powerbi.com/.../ReportSection?noSignUpCheck=1&filter=myTable/myColumn eq 'value'

Then the report should be filtered to the desired result.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[selimovd]

Hey @Anonymous ,

did it work with the ReportLevel Filters?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi