We host all large meetings via Zoom, so my requirement is to fetch the details of every webinar, such as the number of users who joined globally, regionally, and via room, and display that data in a BI dashboard. My plan is to achieve this solution using Power BI and the Zoom API. Please let me know if anyone has achieved this using this method or if there is a better approach I can use here.
Check the Zoom Power BI connector by Vidi Corp for pulling the data on zoom meetings, webinars, participants, polls. It extracts data from Zoom API into an Azure SQL Server database. You can then connect this database to Power BI.
You can see some dashboards that were built using this solution on the page as well