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.
Hi all,
I am new to Power BI, so first of all i am sure this question has been raised multiple times...
Is there no way at all how i can send out an Excel file with underlying date from Power BI service - as an automated process IE every morning?
Kind regards
Jesper
Solved! Go to Solution.
According to link below, this feature is not available yet. Seems like MS is prioritizing this for Paginated reports (which requires premium subscription) and then through PowerBI reports at some point I guess.
But depending on your scenario and what resources you have available at your disposal there's a workaround. In my case, the customers really needed to get the report as an Excel attachment. And the report was basically made up of a large table in PowerBI. Customers didn't want to go through the agony of having to open the report and click export to Excel :).
The workaround was actually outside of PowerBI (that's why I say depending on your resources). Here are the steps to roughly get this done:
This is probably not ideal in most cases but depending on the conditions it may be the best alternative at this time.
https://powerbi.microsoft.com/en-us/blog/e-mail-subscription-time-based-scheduling-now-available/
Found this option using Flow which is close enough to what I neeed
Creating CSV file with Flow
Test went OK, still waiting to see if I get the link to the file by email.
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.
User | Count |
---|---|
50 | |
18 | |
16 | |
16 | |
8 |