topic Re: Automated API call blocked by 2FA in Developer

Automated API call blocked by 2FA

cboisvert — Mon, 11 Nov 2024 10:55:49 GMT

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!

Re: Automated API call blocked by 2FA

Expiscornovus — Mon, 11 Nov 2024 11:49:58 GMT

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

Re: Automated API call blocked by 2FA

sangameshks — Mon, 11 Nov 2024 11:41:53 GMT

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