Forum Discussion
Export Excel automatically (Scheduling)
Can we export data from Power BI to Excel automatically and send it to the client through the mail using scheduling?
Syk
Resident Rockstar
Resident RockstarYou should be able to do this with Power Automate. There's a step that allows you to query a Power BI dataset which you can then save to an excel sheet on a sharepoint site (or other file store) and email out.
As I'm new to Power Automate, I want detailed steps to how to do this?
- Syk
I would suggest posting in the Power Automate forum. I'm sure someone there would be much more helpful than myself. Also a lot of good guides on youtube for just setting up basic flows.
Microsoft Power Automate Community - Power Platform Community