Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello everyone, good evening.
Until last week I was able to connect to azure devops with the query below:
let
url = "https://DOTTO-SA.visualstudio.com",
collection = "DOTTO-SA",
project = "Dotto.co",
team = "Quality",
id = "3b41c01c-53a9-4262-9f95-bbf5ef8debd1",
// Create wrapper for VSTS.AccountContents function as a workaround for the static code analysis in Power BI Service.
contents = (o) => VSTS.AccountContents(
url,
[
Version = Record.FieldOrDefault(Record.FieldOrDefault(o, "Headers", []), "Referer", ""),
IsRetry = Record.FieldOrDefault(o, "IsRetry", false),
ManualStatusHandling = Record.FieldOrDefault(o, "ManualStatusHandling", {}),
Query = Record.FieldOrDefault(o, "Query", []),
RelativePath = Record.FieldOrDefault(o, "RelativePath", null),
Timeout = Record.FieldOrDefault(o, "Timeout", null)
]),
Source = Functions[WiqlRunTreeWorkItemLinkQueryById](contents, url, [Collection = collection, Project = project, Team = team], id)
in
Source
At 00:01 2022-05-11 my query stopped working and I started getting the error:
I'm having difficulties with this problem, I need your help
Thank you
Hi @luandotto ,
Have noticed that 'This operation is not supported for a relative URL', perhaps you can try to check that whether some operations have been changed already which is not supported.
About VSTS.AccountContents, you can refer:
Connect using Power Query and Azure DevOps functions
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 6 |