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
  • 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.