I have a dashboard composed of a single worksheet. For sake of simplicity, let's say there are 200 schools with data on their students' test scores. Each school requires it's own printed dashboard. What I would normally do (which takes way way way too long) is filter on school and print each school from 1 to 200 manually as a PDF.
Is there anyway to resolve this issue? I know there are some new R capabilities which I'm hoping might be the answer. I was thinking maybe there's a way to code some sort of loop that says:
start at school 1, now print school 1 as PDF
proceed to next school on filter
currently at school 2, now print 2 as PDF
.... so on
until print school 200
Any procedure to automate the entire process, from PDF creation to email transmission to the individual schools if you want.
Appreciate any help! Thanks!
I don't think that you can automate the above whole process that loop filter values and auto-generate PDF.
You can consider to create a PBIX file with parameter following the guide in this blog, then send the PBIX file to each school. Each school can filter their own data in the PBIX file by choosing parameter value and upload the PBIX file to service, then print the report.
You can fully automate that process with PowerBI Robots. It allows you to apply filters and send your reports on PDF to as many emails as you want. If you purchase the full version by November 10th, use code TREAT30 for a 30% discount.