Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I'm trying to import data from a REST API, which requires credentials to access. I selected Get Data and then chose "Web" and the following appears:
I enter the URL information of the API and click on OK. the API is password protected, so normally a popup would appear where I would enter the credentials. However this window is not appearing and I go straight to the navigator, which looks like:
From the HTML code, it appears it's accessing a signin page. I have cleared Power BI's cache, as well as tried to delete the old credentials, but it never prompts me to enter my credentials. I was wondering how do I force the authentication window to appear?
Jason
@jasonyeung87 try these resources
https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006
step by step
https://growteq.nl/2017/01/11/self-service-data-ophalen-vanuit-exact-online-in-power-bi/
https://community.powerbi.com/t5/Power-Query/OAuth2-REST-API-as-data-source/td-p/414748
Proud to be a Super User!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.