Forum Discussion
Power Automate button - export pages to pdf or pptx problem
- 4 years ago
ReportLevelFilter works just like URL filters which are explained here https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
If you can dynamically construct a string like this example: "Store/Territory in ('NC', 'TN')" and pass it in the ReportLevelFilters it will filter your report accordingly.
Hi AmosHersch,
Do you know if we can use a solution by including the fields in the Power Automate visual ?
For example I tried if I can get different Dates by triggering the flow with my button, without saving the report and it worked, I tried several times and I received emails with different date.
With this step:
By doing it 2 times with 2 different dates without saving my report, I am able to get the 2 values I selected:
I thought I could do the same but putting this "Element" Field or "Entity" Field in the ReportLevelFilters Filter from the Export to File step, but it doesn't filter the report:
- Do you know if I can use this Element field to make the Export to File dynamic with what the user select without saving it ?
- And do you know how the ReportLevelFilters Filter work ? I really thought it would work like this...
Thank you for your help !
ReportLevelFilter works just like URL filters which are explained here https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
If you can dynamically construct a string like this example: "Store/Territory in ('NC', 'TN')" and pass it in the ReportLevelFilters it will filter your report accordingly.