Forum Discussion

aldodfm's avatar
aldodfm
Frequent Visitor
10 years ago
Solved

Anonymous access

Hello @Community,   I have a power query with a REST api call:   authKey = "Bearer blablablaKey", url = "https://blablablaendpoint.com/api/v1/usage/2016", GetJsonQuery = Web.Contents(url, ...
Need Help
  • fso's avatar
    fso
    10 years ago

    I had the same issue and logged a support ticket with Microsoft because I wanted to build my own Google Analytics queries (include filters, segments, etc).

    Here's the answer I got from the support team:
    This is not possible due to constraints with the way Web.Contents stores credentials. They are stored based upon the URL value passed, and there can only be one URL per Dataset. In this case, you're trying to short-circuit a typical oAuth2 flow (one URL) and call the API (another URL). I made an attempt at using RelativePath to 'trick' the service, but stills require that the root of those two endpoints returned a valid HTTP 200 response to indicate connection success. In this case, https://www.googleapis.com returns a 404. Unfortunately, therefore it is not possible as an uploaded PBIX file. I suggest creating a new issue describing what data you would want to see in the Google Analytics content pack (https://app.powerbi.com/groups/me/getdata/services/google-analytics) and we can see about adding it to the model.

    The only workaround for me so far, is to execute the query elsewhere (for me it's Google Spreadsheet) and connect PBI to that as a data source.

     

DuncanP's avatar
DuncanP
Advocate II
10 years ago

Well that's actually fixed it for me, so thanks!

 

I've modified my json call to:

Source = Json.Document(Web.Contents("https://myapi.com", [Headers=[#"X-API-Key"="Some_GUID"], 
	RelativePath="/api/​method"])),

which now allows it to authenticate properly. In this case I'm lucky that the root url of the api works with anonymous access.

 

 

Duncan

dstramilov's avatar
dstramilov
Helper II
10 years ago

DuncanP,

 

I am trying to solve the same issue, but still getting error, do you mind to write a bit more how you solved this problem please.

 

Dmitry

  • DuncanP's avatar
    DuncanP
    Advocate II
    10 years ago

    Hi Dmitry

     

    Can you post your code and the issue you're having?

     

    Duncan

    • dstramilov's avatar
      dstramilov
      Helper II
      10 years ago

      I was able to fix it using your method.

      let
 authKey = "{""Username"":""USERNAME"",""Password"":""PASSWORDGOESHERE"",""LocationID"":""LOCATIONIFNEEDED""}",
 url = "https://APILINKGOESHERE.com",
 // Uses the authentication/token method to obtain a token
 GetJson = Web.Contents(url,
     [
         Headers = [#"Content-Type"="application/json"],
         Content = Text.ToBinary(authKey),
         RelativePath="/Authentication/AuthorizeUser"
     ]
 )
in
    GetJson

      So thank DuncanP you for your idea!

       

      • DuncanP's avatar
        DuncanP
        Advocate II
        10 years ago

        Glad I could help!

         

        Duncan