Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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),
Solved! Go to Solution.
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.
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.
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"]]),
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.