Iterate through Field Values to Export each as a different slide in a PowerPoint

[mmoeller]

I have a report page set up with a development graph.  There are 248 people with 6 data points each on the graph, and I want to export the same graph for each of them separately to build a PowerPoint presentation with 248 slides.

I just want to iterate the  slide export over a list of field values.  This should be fairly easy.  At this point, I'd also take iteration over PDF export too.

Is it possible and where would I go to learn more about it?  Maybe I'm just dumb, but a week of searching the internet and poking around in forums has led me no where.

Thanks,

Morven

[Seth_C_Bauer]

@mmoeller I'm not aware of a way in which you could auto-generate this. But I am curious as to how feasible a 248 page slide deck would be... what is the purpose of generatind exporting in this manner? What problem are you trying to solve, there might be other methods to try?

[mmoeller]

We already generate this report manually quarterly.  It is used for personnel appraisals.

For our internal distribution, we all have Power BI Pro User Licenses, so we just send the Power BI report and the managers can click through for perusal, however, we also have to share it with subcontractors and non-manager personnel (without publicly publishing the data/report), who do not have Power BI Pro Licences, so we have to create a report to send to them.  And we do, quarterly.  And it's extremely tedious and annoying.

I would probably filter out to only that external manager's personnel then have the export iterate through only those employees and send a smaller report to that external manager, meaning less than 248 slides, but still need a way to iterate the PowerPoint/PDF export.

The easiest solution in my mind would be to publish publicly (which we cannot do with proprietary information) or to get those users Power BI Pro Licences (which i have no control or leverage to do, especially since we are obligated to give them a PowerPoint report anyway).  I am open to other suggestions, though.

[v-joesh-msft]

Hi @mmoeller ,

After my research, I'm afraid it couldn't achieve in Power BI for now. For your requirement, you can come up with a new idea and add your comments there to make this feature coming sooner.

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.