Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gerasimovav
Helper III
Helper III

PowerBI Export - Scheduling and Send Export to Excel by Email

Hello Coleagues! 

Every table from Power BI Report could be exported to excel. We're using it to send negitiated reports on Excel format. But we have to open Power Bi report, look for the table and export it to Excel, then send it to customer every month. 

I want to schedule and send excel files by email from Power BI Report. Is it possible? 

1 ACCEPTED SOLUTION

Hi there

Yes it is currently only available in Power BI Premium




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

8 REPLIES 8
KiranHosakote
Helper V
Helper V

Hi @gerasimovav , @GilbertQ , 

 

See https://medium.com/bi-helper/automate-the-export-of-filtered-and-sliced-power-bi-table-and-matrix-da... for a solution from BI Helper. 

 

This requires a single Power BI Pro license (or higher) and you can email your Excel files to interenal and external users - customers, vendors or employees. 

GilbertQ
Super User
Super User

Hi there

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ !

Thank you for answering! It's very interesting functionality! As I understand it available in Power BI Premium only, isn’t it?

Hi there

Yes it is currently only available in Power BI Premium




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi GilbertQ,

do you know if something changed in this matter? Is this functionality available for all now?

BR M.

hi @mgkct 

 

It is if using Power BI Premium or Premium Per User with paginated reports as indicated by @romgut 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

How to make sure or change my existing report to paginated report?

Check some Paginated Reports In A Day workshops 

Power BI Paginated Reports in a Day course - Power BI | Microsoft Docs

 

You would need to install the Power BI Report Builder and create the paginated report there, then you can publish and schedule it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors