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! It's time to submit your entry. Live now!
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.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 8 | |
| 8 | |
| 7 |