Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Resolver I
3 years ago

OAuth authentication method isn't supported for this data source - partial web URL

I originally set up a dynamic URL until I found out that it would not refresh in the service.  

(VarURL as text)=>
let AnalyticsQuery =
let Source = Json.Document(Web.Contents(VarURL,
[Query=[#"query"="  ...etc...

 

So, then I tried to supply a relative path.   This works in the Desktop but not in the Service.   

(VarURL as text)=>
let AnalyticsQuery =
let Source = Json.Document(Web.Contents("https://api.loganalytics.io/v1/workspaces/", [RelativePath = VarURL & "/query", 
Query=[#"query"="  ...etc...

 

I believe this issue may be because the static part of the URL is only a partial path and it does not work on its own.   I need to be able to utilize OAuth2 for this.    How can I make this work? 

 

4 Replies

  • HI Alicia_Anderson 

     

    I would change the way you query the data by first just going into the static part of the URL.


    Then in the next steps once it loads the data to then put in the variable part. Because this is not part of the initial URL it will remain static?

    • Alicia_Anderson's avatar
      Alicia_Anderson
      Resolver I

      That is part of the problem.   The static part is not a complete URL and will not resolve on its own. 

       

    • Alicia_Anderson's avatar
      Alicia_Anderson
      Resolver I

      In Data source settings in the Desktop, the source isn't shown.   At the bottom is a message that states "Some data sources may not be listed because of hand-ayuthored queries."