Forum Discussion
Power Automate button - export pages to pdf or pptx problem
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.
Hello AmosHersch,
So it is impossible to expect the "export to file" to be dynamic depending on the selections we do in the different slicers of the report ?
It is necessary that the print button take into account what we select in the slicers for the user...
Thank you for your answer !
Bastienlin_ that's right, unless you have the Power BI report embedded in your own app, and then you can use Power BI Javascript API to capture bookmark of current state of the report, and provide that bookmark in the API request.
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.
- 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 ?