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.

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

 

 

 

  • lbendlin's avatar
    lbendlin
    Super User
    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
       

      It worked after i mention Anonymous on Web and it pulled from .pbix .

       

      Thanks you for help:)