How can I automate the creation of custom reports for each individual respondent of the survey that includes filtered views set for that respondent? I don't want to email the reports. I simply want them stored to One Drive or Google drive so that I can preview each report before emailing them out.
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. BI Helper has an option to download your PDFs to your OneDrive / Google Drive, review and then email them to users inside and outside your organization.
Use a Power Automate Flow to accomplish that.
User | Count |
---|---|
215 | |
81 | |
74 | |
71 | |
50 |
User | Count |
---|---|
184 | |
93 | |
83 | |
76 | |
74 |