Forum Discussion

rdubs's avatar
rdubs
Frequent Visitor
7 years ago
Solved

API authentication error on scheduled refresh!

I have a couple of API feeds which I connected through the web connector. These require an api key for authentication, I added this in the header using the advanced section.   The data refresh work...
Need Help
  • blopez11's avatar
    blopez11
    7 years ago

    Try this, substituting in your api key, and see if you see the same error

     

    let
    vBaseUrl = "https://api.projectmanager.com",
    vPath = "api/v1/projects.json",
    vHeaders = [ #"apikey"="this is where i put my key" ],
    Source = Web.Contents ( vBaseUrl, [RelativePath=vPath, Headers=vHeaders] ),
    Json = Json.Document ( Source )
    in
    Json

opsus's avatar
opsus
Regular Visitor
6 years ago

I tried this exactly same approach and my datasets seems to be working correctly as webapis, but I still get the credential warnings on the powerbi service when I try to connect the gateway even using anonymous authentication.

Any suggestions?