Forum Discussion
Export button in Power BI Report using Power Automate
You are missing a couple of things.
- your filters must be given to the Power Automate visual in Power BI. The filters must work on report level
- the running user (USERPRINCIPALNAME) must also be given to the visual as a measure
- in your flow you need to use the data that is transported from the Power BI visual to set the report level filters for the export
- in your flow you need to use the user email from the visual to set the recipient of the email.
Why can the Power BI Report users not just use the existing Export funtionality in Power BI?
You are missing a couple of things.
- your filters must be given to the Power Automate visual in Power BI. The filters must work on report level
- the running user (USERPRINCIPALNAME) must also be given to the visual as a measure
- in your flow you need to use the data that is transported from the Power BI visual to set the report level filters for the export
- in your flow you need to use the user email from the visual to set the recipient of the email.
Why can the Power BI Report users not just use the existing Export funtionality in Power BI?