Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dovico API - dynamic data sources aren't refreshed error

  I am doing Dovico API integration with Power BI, I get the data that I need and successfully publish but I am unable to refresh or set up the gateway as there is an error-  "This dataset includes ...
Interesting Links
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Specify the authentication type as anonymous. Use Postman or similar to test the call. Your headers section looks weird.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago
     

    I tried using the relative path and am new to the power query. got lost! as i get error.

     

     

    = let
    Source = Xml.Tables(Web.Contents("https://api.dovico.com/TimeEntries",
    [RelativePath="/?daterange=2020-01-01%202025-12-31&version=5"],
    [Headers=[#"Authorization"="WRAP access_token=""client="&DovicoAccessToken&"&user_token="&DovicoUserToken&""""]]))
    in
    Source

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      I recommend using the Query parameters. RelativePath is not required, it seems.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago
         
         

        Okay added a date range table and still I see an error on the Power BI web. but the thing is I see Gateways and now asking credentials? I have only tokens for Dovico,

         

        (DateR as text) =>
        let
        Source = Xml.Tables(Web.Contents("https://api.dovico.com/TimeEntries/?version=5",
        [Query=[daterange=DateR ],
        Headers=[#"Authorization"="WRAP access_token=""client="&DovicoAccessToken&"&user_token="&DovicoUserToken&""""]]))
        in
        Source