Yammer Usage Reporting

[BMoreOs]

I see related posts but they are years old.  HR and Marketing want to see usage reports for Yammer.  Obviously this is very valuable for them.  Right now I export, clean it all up and send it.  That was quarterly and now they want it weekly which takes a lot of my time.  

Is there any way for me to setup and send automated reports to them?  Maybe power automate?  I believe I can grant them the Office reports reader role, right?  But does that grant access to anything else that they should potentially not be able to see?

Thanks

[#2]

It will grant access to all the reports, and can potentially expose personal information, etc. If you are only interested in the Yammer report, an automated solution (PowerShell script, Azure Runbook, Flow, etc) that fetches and emails it is probably the best option. Here's the relevant Graph endpoint to use: https://learn.microsoft.com/en-us/graph/api/resources/yammer-activity-reports?view=graph-rest-1.0