Forum Discussion

Anonymous

Not applicable

4 years ago

API Unable to refresh in Power BI Service: The credentials provided for the Web source are invalid.

Hi there, I'm currently trying to refresh a connection to an API in Power BI Service, but I get the error: "The credentials provided for the Web source are invalid." In Desktop, it works fine...

Responsive Resident

4 years ago

Have you checked your Data source credentials in the Schedule refresh settings on your dataset. Sometimes you might need to tell it to skip test connection if you're authenticating via the headers

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable
4 years ago
Unfortunately this doesn't resolve my issue.
- mattww
  Responsive Resident
  4 years ago
  Anonymous , one other thing to check is whether you are using Basic Auth?
  
  If you are and have put your credentials in when prompted on Power BI Desktop (i.e. see below), then you don't need the headers in your Web.Contents function as well.
  
  Or alternatively, if you are keeping the authorization header in your Web.Contents, select Anonymous in the above dialog
  
  Just a thought
- mattww
  Responsive Resident
  4 years ago
  Hmm, sorry to hear that. I have had similar fiddly issues with API connections and the service not liking it. I would suggest logging a call with Microsoft Support as it looks like you've tried all the right things to make sure the Power BI Service can evaluate the query fine.
  
  I don't know how complicated your report is, so the other thing that might be worth trying is publishing a very simple report made from scratch with just one basic API connection in it. You might have an old data connection in there.
  
  Also, in Power BI Desktop open your data source settings and Clear all permissions in the report. Make sure your authentication method is set to anonymous when reprompted.
  
  Good luck, sorry I can't be of more help

Related content