Automate - PowerBI Activity Logs

[PGhosh]

Hi Everyone, I want to automate the process of downloading the PowerBI activity logs. I have PowerShell script that can download the logs, however I want to schedule the process to download the logs periodically preferably using SSIS.

Please share the details/process if anyone has implement the solution? 

Also, how can we pass the login credentials (without prompt) required to login to PowerBI service when automating the process? 

Since when we use the PS command - 'Login-PowerBI' or 'login-powerBIServiceAccount' a pop up window appears to enter our credentials. 

I would appreciate any help. 

Thanks! 

[GilbertQ · Accepted solution]

Hi there

Here is my solution to get this working with PowerShell, which you can modify to use and call PowerShell with SSIS

https://www.fourmoo.com/2020/02/12/how-you-can-store-all-your-power-bi-audit-logs-easily-and-indefin...

[PGhosh]

Thanks @GilbertQ appreciate your help. You solution  really helped 🙂 

[GilbertQ]

Happy to help and glad it is helping others!