Ideas to automate export of report w/o premium service?

[therealomacoder]

I am doing work for a very small client, YTD revenue is $4,227.

They would like to have a dashboard export to PDF and sent to an email list on an automated basis.

It looks like I would have to ask this client to pay $4,000 PER MONTH to add this ability? I'm not sure how to break this news to my client 🙂 

[KiranHosakote]

Hi @therealomacoder 

To export your Power BI report to PDF with filters and slicers (with a Power BI Pro license), see https://medium.com/bi-helper/automated-distribution-of-power-bi-reports-and-dashboards-25fde6c68af0.

BI Helper is a third-party SaaS tool that automates the generation and emailing of PDF / PPTX reports from Power BI to users inside and outside your organization. Subscription plans start at $50 per month. 

[collinq]

Hi @therealomacoder ,

If you are wanting a report output in a certain format and not wanting to use Premium, your best bet is probably to use Power Automate to get the result and email them in a PDF.

[therealomacoder]

Oh wonderful! I was afraid PowerAutomate would also require the report to be in a premium workspace. I'll give it a try, thank you!!

[therealomacoder]

Unfortunately it looks like PowerAutomate cannot be used either, it reports an error:

Report requested for export is not on dedicated capacity

https://powerusers.microsoft.com/t5/General-Power-Automate/quot-Report-requested-for-export-is-not-o...