Forum Discussion

jasonyeung87's avatar
jasonyeung87
Helper V
4 years ago
Solved

Enter credentials for Web API when publishing to Power BI Service

Hi, I created a report on Power BI desktop which grabs data from an API. I use the "Web" data source and enter the Web API key as the credentials. It connects to the API and I'm able to generate var...
Need Help
  • jasonyeung87's avatar
    jasonyeung87
    Helper V
    3 years ago

    Hi,

     

    thanks for the link. I tried the suggestions in the link by adding the headers in the code. But it seems to not connect. I get the error "We couldn't authenticate with the credential provided". error.

     

    The credential (API Key) was changed recently.

  • jasonyeung87's avatar
    jasonyeung87
    Helper V
    3 years ago

    Hi,

     

    I tried using basic authentication, but adding the API key (instead of the user name). I was able to make the connection. I think it is the nature of the REST API that I was using. I thought it needed to be the Web API authentication method. I'll mark your solution as accepted.

     

    • EdwngJs's avatar
      EdwngJs
      Regular Visitor
      1 year ago

      Hello, Could you please show step-by-step how you did? 

      Thanks