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]

dpombal's avatar
dpombal
Post Partisan
6 years ago

Same issue... similar to mine... bidax solution is not valid for me

  • Patrick_05's avatar
    Patrick_05
    New Member
    5 years ago

    Hello,

    My schedule refresh will not work and gives me the following error(see below). I am using the On-prem Report Server. The datasource is Smartsheet & SharePoint. I can manually go into the Power BI Desktop and refresh the report, however the schedule refresh will not work in the Report Server? Is schedule refresh not supported in Report Server?

     

    Thanks,

    Patrick

     
     

    Error message details:

    Several error occured during data refresh. Please try again later or contact your administrator.

    [0] -1055784932: The import Smartsheet.Tables matches no exports. Did you miss a module reference.