Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!