Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
We want to send Power BI reports to customer's email on a schedule basis in an Excel format. I tried using Power automate but the format available is only pdf, ppt. But how can we generate using excel format?
Thank you
You can use the Power BI REST API to export a Power BI report in an Excel format. You can use Power Automate to call the REST API and then email the Excel file to your customers on a schedule basis.
Here is the basic steps you can follow:
Get an access token: Use the Power BI authentication API to get an access token that you can use to call the Power BI REST API.
Export the report: Call the Power BI Export API and specify the format as "Excel". You can use the access token obtained in step 1 to authenticate the request.
Save the Excel file: Save the exported report in a specific location where you can access it later.
Email the Excel file: Use Power Automate to email the Excel file to your customers. You can use a recurring flow to schedule the email at specific intervals.
Please note that this approach requires some technical knowledge and coding skills. You can find more information about the Power BI REST API and how to use it in the official documentation.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.