Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Scheduled Refresh with Web Source Not Working

Hi all,   I have built a PBI report on PBI Desktop using SQL database and Web as data sources. The Web source is used to call http://useragentstring.com and the report passes user agent values in ...
Refresh
Report Server
scheduled refresh. web source
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I also have a similar issue and to solve it i did below as per the post by Anonymous 

 

I have a API URL which works like this :
https://jira.company.com/rest/api/2/issue/RC-2345/worklog


to get the data from JIRA , the param is "RC-2345" in this url , rest is static , how can we create a similar funtion to pass the JIRAID as param , https://jira.company.com/rest/api/2/issue/JIRAID/worklog

 

i tried the below sample function but it doesnt pass it correctly.

let WorkLog = (JIRAID as text) =>        
    let Source   = Json.Document(Web.Contents("https://jira.company.com/rest/api/2/issue", [Query=[JIRAID]], [RelativePath="worklog/"]))
    in  Source
in WorkLog

but i get the error as 

 

An error occurred in the ‘CalcWorkLog’ query. Expression.Error: 3 arguments were passed to function which expects between 1 and 2.
Details:
Pattern=
Arguments=[List]

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Was able to fix the error by the approach below but the sync issue still exists for data refresh:

 

let WorkLog = (JIRAID as text) =>        
    let Source   = Json.Document(Web.Contents("https://jira.company.com/rest/api/2/issue/" & ""&JIRAID&"", [RelativePath="worklog/"]))
    in  Source
in WorkLog

Created a param as shown on this url http://prntscr.com/pm3wod with a default value.

 

Error on Data Set sync is as below

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for "JIRA Sub Task WorkLog"
Data source for "JIRA Main Task WorkLog"
Discover Data Sources
Query contains unsupported function. Function name: Web.Contents