I need to automate a PowerShell script that accesses the Power BI Rest API and does some stuff. I have the script working fine. The hurdle is how to authenticate with Power BI when automating the PS script? Note that my organization uses MFA authentication.
Thanks much!
Hi @Dan_Sprague ,
I'd recommedn go for SPN Autentication instead of username/password type.
Pls see my answer https://stackoverflow.com/a/57344477/7073340
Hi @Dan_Sprague ,
You may refer to the links:
Power BI REST API using postman - generate embed token.
REST API Silent Authentication (Token)
Power BI REST API: How to get authentication token with PowerShell Cmdlets
Get an authentication access token
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!