Re: Export Excel automatically (Scheduling)

Anonymous · ‎06-27-2023

Can we export data from Power BI to Excel automatically and send it to the client through the mail using scheduling?

Syk · ‎06-27-2023

You 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.

Anonymous · ‎06-27-2023

As I'm new to Power Automate, I want detailed steps to how to do this?

Syk · ‎06-28-2023

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