Forum Discussion
Automated API call blocked by 2FA
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!
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
2 Replies
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
cboisvert Use Selenium with manual 2FA for one-time authentication, but be prepared to refresh the session periodically
