Export Excel automatically (Scheduling)

[Anonymous]

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

[Syk]

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]

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