Query contains unsupported function. Function name: Web.Contents for web API

[jesus_heredero1]

Hello,

I have tried your solution 

contents = Web.Contents(#"URL_jenkins_1", [RelativePath="/bat/view/Deploy-XLD/job/Deploy-XLD-OSB12-EPI/api/json", Query = [pretty="true"]]),
//RawData = Web.Contents("https://yourcompany.atlassian.net", [RelativePath="rest/api/3/search", Query=[jql=JQL,startAt=Text.From(StartAt) ], Headers=[Accept="application/json"]]),

json = Json.Document(contents),

#"URL_jenkins_1 => url server Jenkins

But It,s the same,  work perfectly in Power Bi Desktop but when I publish it in the service PowerBi doesn´t work. 

Curiosly in the same report,  I connet with Jira with webcontens and in this case It is working. In teory is the same or similar  call

contents = Web.Contents(#"URL"&"/rest/agile/1.0/board/1779/issue?fields=components,parent,resolution,assignee,customfield_11023,created,status,fixVersions,timetracking,customfield_11100,resolutiondate,issuetype,labels,customfield_10758,summary,worklog&jql=project in (EEDS, PS2PD) and updated >= -120d",[Query = [maxResults= Text.From(pageSize), startAt = Text.From(skipRows)]]),
json = Json.Document(contents),

[Anonymous · Accepted solution]

@jesus_heredero1 

Check out the “Faking Out” Web.Contents discussion regarding to using Relative path and Query options.

http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

You could also create a support ticket here.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[jesus_heredero1]

Thank you ,   It works

I add a complete URL with the path complete and then work

URL_jenkins_2 = URL_jenkins_1 & "/bat/view/Deploy-XLD/job/Deploy-XLD-OSB12-EPI/api/json?pretty=true",

contents = Web.Contents(URL_jenkins_2, [ Headers=[Accept="application/json;odata=nometadata"] , Query = [pretty="true"]]),