Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
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.
Hey @Anonymous ,
did it work with the ReportLevel Filters?
I'm curious if you could solve this issue 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
20 | |
18 | |
17 | |
9 |