Forum Discussion
Helper IIScheduled refresh fails
Hi All!
I am running the following query:
Source = Json.Document(Web.Contents(“https://jira-rest.app.name.com/jira/rest/api/latest/search?jql=filtername))
And getting the following error when running scheduled update - [0] -1056505856: COM error:
Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, The given data source kind is not supported. Data source kind: UnknownCallsite..
A url is my parameter (if you ever used jira this is just a jql query which then "downloads" bunch of data to power bi). I am confident the code is intact (I pasted just part of it due to confidentiality reasons), as I can run refresh manually or scheduled as long as I run the report revisions which I have never opened with newer versions of Power BI desktop (the same query, same code, same report, just saved months ago under different file name, earlier revision). They run fine on May 2021 RS, again as long as I do not touch them with the newer vversions of Power Bi Desktop. This has started for me when enabled meta data preview in Power Bi Desktop January 2021 and continues on May 2021 version. Any suggestions would be greatly appreciated.
6 Replies
- lbendlin
Super User
Web.Contents()
please check your code spelling and punctuation.
sebaAbsolutely, my bad when typing from one screen to another, the code syntax is correct, something else (power bi change?) is the problem:
Source = Json.Document(Web.Contents(“https://jira-rest.app.name.com/jira/rest/api/latest/search?jql=filtername))
Hi seba,
I had the same issue with a the jira search api rest. I didn't find the root cause but I fixed it thanks to the workaround detailed in this article. Chris Webb explains how to use the optional parameters of the Web.Contents function to have a successfull dataset refresh. Hope it will help you too.
- lbendlin
Missing double Quotes ? Is filtername a parameter?
- seba
I have inherited this and I am not entirely sure if I get it right, but as far as I know url is my parameter (if you ever used jira this is just a jql query which then "downloads" bunch of data to power bi). As mentioned above, I am rather confident the code is intact (I pasted just part of it due to confidentiality reasons) as I can run refresh manually or scheduled, as long as I use reports which I have never opened with newer versions of Power BI desktop (the same query, same report, just saved months ago under different file name, earlier revision). The query has not changed since 2018 and has been working fine, I also understand that is the code was wrong manual refresh would not work too. Either way, the code is definitely not the problem. Truly appreciate you trying to help, thanks!
