Forum Discussion
Can not connect with REST API. We couldn't authenticate with the credentials provided.
Hello,
I am trying to connect with our REST API Source in Power BI, but i get the error message "We couldn't authenticate with the credentials provided. Please try again."
When I use the same URL and API Key in Postman it works fine.
In the Access Web Content I selected "Basic" and put in the filed "Username" my API Key, as described in other solutions. Also I tried in the Access Web Content "Web API", same error.
In Postman I have to specify which Key I use, in my case it is "X-API-KEY" do I have to specify this somewhere in PBI or what am I doing wrong?
Kind regards Björn
Hello Parry,
Thank you for the link to the Youtube video, it helped me to figure out how to connect to the API.
kind regards,
Björn
6 Replies
bkoenen check this view, it talks a lot about API as a source. Accessing API and web service data using Power Query - by Chris Webb - YouTube
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hello Parry,
Thank you for the link to the Youtube video, it helped me to figure out how to connect to the API.
kind regards,
Björn
bkoenen glad to hear it is solved. I would recommend accepting an appropriate reply as an answer so that it can help others as well.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hello!, I am looking to know how to connect to the OnPremise DataGateway my REST API, I can not do it
Hi Folks,
I am implementing integration between servicenow and power BI, pulling all incident from servicenow table to Power Bi . iam using Rest api explorer to generate "URL" and using basic credentails iam getting as follows "We couldn't authenticate with the credentials provided. Please try again.", please can anyone help me on this.
Hello bkoenen!
You might want to try an alternative solution? We've built an app for Servicenow and Power BI integration: Power BI Connector for Servicenow. It's easy to use, it's fast and automated.
Also, I’d like to propose to read the article "Connect ServiceNow to Power BI: REST API vs Power BI Connector".
Hope this helps,
Daria
