Can not connect with REST API. We couldn't authenticate with the credentials provided.

[bkoenen]

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

[Anonymous]

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

[aanumanthula]

Hi Folks,

@amitchandak ,

@Idrissshatila 

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.

[Syndicate_Admin]

Hello!, I am looking to know how to connect to the OnPremise DataGateway my REST API, I can not do it

[parry2k]

@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.⚡

[parry2k]

@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.⚡

[bkoenen · Accepted solution]

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