Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Running an API to Azure DevOps to return the work items for a build within either a dataflow or DataMart and receive the same error.
Using a Blank Query with the following:
let
Source = VSTS.Contents("https://dev.azure.com/org/" & ProjectNm & "/_apis/build/builds/" & BuildID & "/workitems?api-version=5.1")
Error is The import VSTS.Contents matches no exports. Did you miss a module reference?
Hello,
Did you find any solution for the issue?
As I am having similar issue where my report pulling work item records from Azure DevOps.
In one of the AddColumn step I am using VSTS.Contents() to call API and passing row context WorkItemId to load some of the properties which are not available from OData or AnayticsView of azure DevOps. This step works fine in PBI Desktop/Semantic model and is good even after the report is published to the Service.
Here is the step that I was referring:
#"Add VSTS Data" = Table.AddColumn(oData_Source, "VSTS", each Json.Document(VSTS.Contents("https://dev.azure.com/OrgName/ProjectName/_apis/wit/workitems/" & Number.ToText([WorkItemId])))),
As this step is taking lots of time to pull data from the API so I am planning to move the data model to Dataflow in PBI Service. But unfortunately the VSTS.Contents() does not seems working in the Dataflow and gives error as below, even if exactly same step works in Semantic model.
Expression.Error: The import VSTS.Contents matches no exports. Did you miss a module reference?
Please help if anyone has faced same issue and how you have resolved this?
Thanks,
Prabhat
I am facing the same issue as well.
The OData query works perfectly in PBI desktop.
The moment I use the same OData query, specifically VSTS.Contents, it doesn't work and I get this error.
"Expression.Error: The import VSTS.Contents matches no exports. Did you miss a module reference?"
Hi @EricParvin ,
Based on the available information and access, we need to do further investigation.
Please check if Similar threads helps
Expression.Error: The import [custom function] mat... - Microsoft Power BI Community
Power Query / Get & Transform – The import xxx matches no export. Did you miss a reference?
Best regards.
Community Support Team_ Caitlyn
Thank you for the links. I checked them and they seem to relate to local resources not having the correct modules. The issue I am encountering is within the dataflow or DataMart.
Forgot to mention, the API calls work within PBI Desktop. The issue is present when running in the dataflow
Hi, are there any additional steps I can take to troubleshoot this issue? It appears to be within the dataflow so I am not sure how much information I can provide outside of the error message.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
33 | |
26 | |
23 | |
19 | |
15 |
User | Count |
---|---|
49 | |
39 | |
24 | |
20 | |
20 |