The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello!
I have a simple Azure DevOps REST API query (because OData doesn't have information about releases) :
let
httpResponse = VSTS.AccountContents("https://vsrm.dev.azure.com/{org}/{proj}/_apis/release/deployments?$top=100&?api-version=6.0"),
json = Json.Document(httpResponse),
List = json[value]
in
List
And after loggin in with organization account it works fine from PowerBI Desktop.
That's good and now it's time to publish and enjoy the Scheduled refresh feature.
Ok. Publish succeded.
Going to to Datasets -> Settings -> Data source credentials.
Ok. Looks like I need to auth again. Click Edit credentials.
And here, interesting, doesn’t really matter what auth method I will chose I will get this “nice” error message that expands beyond the screed borders.
This error message sais that the resource can not be found…
What am I doing wrong and how to configure scheduled refresh?
Solved! Go to Solution.
It turns out that a VSTS.AccountContents(...) support ONLY data from Azure DevOps boards (work items)!
It does not support anything else like Pipelines, etc. So it can not be treated as a full replacement for Web.Contents(...).
Unfortunately, the documentation and error messages are totally misleading.
It turns out that a VSTS.AccountContents(...) support ONLY data from Azure DevOps boards (work items)!
It does not support anything else like Pipelines, etc. So it can not be treated as a full replacement for Web.Contents(...).
Unfortunately, the documentation and error messages are totally misleading.