Forum Discussion
Export published report into excel template
Hi unknown917, you can use Power Automate to export data from Power BI report to Excel - Power BI Export Buttons (databear.com). Be aware that data you export from Power BI will go trhough a loop (i.e. row by row), therefore I would reccomend this approach only when you need to export a limited amount of rows.
In case you need to export a lot of data in a standartized way, you can use Power Query directly in Excel - Excel Power Query tutorial for beginners: how to get, use and auto-refresh (ablebits.com)
Good luck with your project! π
Thanks, Sergii24 - the key here is I was curious if I could export into an established worksheet, instead of just exporting the data out to a new file.
Yes, you can π Take a look at some tutorials online on using Power Query in Excel (there are plenty of them!), it should asnwer most of your questions π
Good luck with your project!