Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.