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! Learn more
Good Afternoon All
I have a requirement below. But I am unsure of the best solution. Please could someone advise me and which is best to do.
I have several dashboards and data sets built, all simple tables, currently each day I have a member of staff who exports the data from BI desktop into excel and send the reports to the clients via email. I would like to automate this process and get the reports send to both external and internal users. They would be emailed out with and excel attachment. Which is the best way of doing this?
I have looked into licensing, pro premieum etc, but not sure i fully understand any help would be arppricated.
See if this meets your requirements. https://medium.com/bi-helper/automate-the-export-of-filtered-and-sliced-power-bi-table-and-matrix-da...
All you need to implement is a single Power BI Pro license.
You can automate this either with Microsoft's Power Automate, Inforiver's Matrix custom visual, or a couple other third-party solutions that exist out there, depending on your exact requirements.
Advance 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.