Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi there,
Is there away I can schedule export data to excel on a daily basis from my PowerBi report?
Thanks
Matt
Solved! Go to Solution.
Hi @MattC2020 ,
You could use Paginated Reports to get this done by connecting it to the same dataset. And then using the Subscription email from Paginated reports and attach the Excel file. For more details, please refer to https://docs.microsoft.com/en-us/power-bi/consumer/paginated-reports-subscriptions
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @MattC2020 ,
You could use Paginated Reports to get this done by connecting it to the same dataset. And then using the Subscription email from Paginated reports and attach the Excel file. For more details, please refer to https://docs.microsoft.com/en-us/power-bi/consumer/paginated-reports-subscriptions
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
No. The tool MS has for that is a Power BI dataset connector in Excel from Office 365 that allows you to refresh Excel from a Power BI report. Or you can use the older Analyze in Excel feature.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAdvance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.