Hey @Lancy_vini ,
Yes, this requirement can be achieved using Microsoft Power BI, but exporting report table data directly to Microsoft Excel through an automated email subscription is not available for standard Power BI reports. However, there are a few practical solutions you can use.
One common approach is to use Power BI Paginated Reports. Paginated reports support email subscriptions where the report can be automatically sent in formats like Excel, PDF, or CSV. When the subscription runs, the system generates the file with the latest data and sends it to the selected users. However, existing Power BI reports cannot be directly converted into paginated reports with a single click. You would still need to recreate the layout in Power BI Report Builder, although you can reuse the same dataset or semantic model from your current report so you don’t need to rebuild the data model.
Another option is to automate the export using Microsoft Power Automate. With Power Automate, you can schedule a flow that exports data from a Power BI dataset or report and then sends it as an Excel file in an email. This approach works well if the requirement is mainly to send table data rather than a formatted report.
A simpler alternative, if users only need access to the data, is to connect Excel directly to the Power BI dataset using the Analyze in Excel feature. This allows users to refresh the data in Excel whenever needed, although it does not automatically email the file.
In summary, the easiest automated email-to-Excel solution is usually Paginated Reports with subscriptions, while Power Automate is a good option if you want a more flexible automation workflow without rebuilding the report layout.
If this explanation helped, please mark it as the solution so others can find it easily.
If it helped, a quick Kudos is always appreciated it highlights useful answers for the community.
Thanks for being part of the discussion!!!
