Automated API call blocked by 2FA

[cboisvert]

Hello everyone!

I'm looking to set up a Python script that automates logging into my PowerBI account, navigating to a dashboard, and sharing a screenshot of that dashboard to a Slack channel once every day.
I'm struggling with 2FA, as this prevents me from automating this process. Any advice on how to get around the challenges with 2FA without actually disabling it? 

Thank you!

[sangameshks]

@cboisvert Use Selenium with manual 2FA for one-time authentication, but be prepared to refresh the session periodically

[Expiscornovus · Accepted solution]

Hi @cboisvert,

You could for example use an Entra Id app registration/service principal to interact with the Power BI api's:

https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal

Edit: And here are two code samples of that approach:

https://github.com/AntoineDW/powerbi-rest-api-python

https://github.com/areed1192/power-bi-python-api

Found in this thread: https://community.fabric.microsoft.com/t5/Developer/Connect-to-Power-BI-API-via-Python/m-p/2302692