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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NaveenMohan
Frequent Visitor

Export Power BI report to PDF using Power Automate with filters applied

Hi,

 

We have a requirement on Power BI report. Every month we need to export one perticular report to PDF for n number of members and store it in SharePoint/StorageAccounts. I found "https://wisedatadecisions.com/2021/01/18/filter-email-power-bi-report-pages-using-power-automate-exc... document for the reference. My question is what is maximum number of PDF's we can export if we use the Power Automate.

 

If we want to export one perticular report to more than 20000PDF's based on the condition(For each member need to export one seperate PDF's), what is the best approach. Can anybody help me out here.

 

Thanks in advance,

Naveen

 

 

1 ACCEPTED SOLUTION

Hi @NaveenMohan ,

 

According to your description and the literature you provided, using power automate is the best way to go. As stated therein, it enables sharing of reports to multiple customer groups.

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

View solution in original post

3 REPLIES 3
v-mengzhu-msft
Community Support
Community Support

Hi @NaveenMohan ,

 

This is a known limitation on the power automate in power bi. I don't see any limitation on the number of PDFs exported.

vmengzhumsft_0-1667787441360.png

Related link:

Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Learn

 

Regarding your needs, I don't quite understand why you would need to export so many PDF files. If you need to share to many users, I think you can create a group of users and share to them uniformly.

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Hi Selina zhu,

 

Actually the users will not have tenant access and our requirement is to export the PBI file into PDf and store in some SharePoint location and the file will be send to the use accordingly.

 

If there are any other solutions, please guide us to it.

 

Thanks,

Naveen

Hi @NaveenMohan ,

 

According to your description and the literature you provided, using power automate is the best way to go. As stated therein, it enables sharing of reports to multiple customer groups.

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors