We have a Power BI Professional license. Our management needs to know the Power BI Usage metrics on an enterprise scale. This would include information on report access frequency, who is accessing the reports, report creators, access times, dataset types and sizes, etc. We would like to create a Power BI Report that has and enterprise view that can be drilled down to workspace and to artifact. There does exist the Usage Metrics report but this is on a report basis, there is also the Usage metrics report but that is only available to Power BI Administrators. We would like to collect data for more than 90 days as well.
Myself and 3 other members of our team are Power BI Administrators. With these permissions we have access to the Power BI Activity log where the desired data exists. I have read the following documention on accessing the Power BI Activity log and tracking Power BI Usage.
https://learn.microsoft.com/en-us/power-bi/guidance/admin-activity-log
https://learn.microsoft.com/en-us/power-bi/admin/service-admin-auditing
I am able to run the above Power BI REST APIs in Powershell. However, we would like an automated process that runs on a daily basis as per a schedule. We do have Visual Studio with Data Tools. Would it be possible to use SSIS where the Powershell scripts can be run to extract the data from the Power BI Activity log and then load it into a database? Would this be recommended or would another approach be better? We do not have access to Azure Cloud shell but could request it if necessary. Would Azure Data Factory be better for this? Any help on how to approach this and with a solution would be appreciated.
