Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
getting this error when i tried to create dataflow in PowerBI service
Expression.Error: The import VSTS.Contents matches no exports. Did you miss a module reference?
Solved! Go to Solution.
Hi @sravs2007
The error message "Expression.Error: The import VSTS.Contents matches no exports. Did you miss a module reference?" typically occurs in Power BI Dataflows when a custom or unsupported Power Query function or connector is referenced but not available in the Power BI service environment. In this specific case, VSTS.Contents refers to a function or connector related to Azure DevOps (formerly Visual Studio Team Services - VSTS) or Azure DevOps Services, which is not a built-in or supported connector in Power BI Dataflows.
Power BI Desktop supports many connectors and custom functions that can be used when building reports locally, but when you move to Power BI Service and try to create or refresh a dataflow, the Power Query engine there has a more limited set of connectors and functions. If you are trying to connect to Azure DevOps (ADO) data using a connector or function like VSTS.Contents, it won’t work in dataflows because the service does not support this connector or function natively.
To resolve this, you might need to:
Use supported connectors in dataflows, such as the Azure DevOps Analytics connector if available.
If you require advanced API calls, use Power Query Web.Contents with proper REST API calls to Azure DevOps REST APIs instead of relying on a connector.
Consider moving the complex transformation steps to Power BI Desktop or Azure Data Factory, and then push a simpler data source to the dataflow.
Verify that all referenced functions are supported in Power BI Service for dataflows.
In summary, the error means that the function VSTS.Contents is not recognized in the dataflow environment, and you will need to adjust your query to use supported methods for connecting to Azure DevOps data within Power BI dataflows.
Hi @sravs2007 ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Hi @sravs2007
The error message "Expression.Error: The import VSTS.Contents matches no exports. Did you miss a module reference?" typically occurs in Power BI Dataflows when a custom or unsupported Power Query function or connector is referenced but not available in the Power BI service environment. In this specific case, VSTS.Contents refers to a function or connector related to Azure DevOps (formerly Visual Studio Team Services - VSTS) or Azure DevOps Services, which is not a built-in or supported connector in Power BI Dataflows.
Power BI Desktop supports many connectors and custom functions that can be used when building reports locally, but when you move to Power BI Service and try to create or refresh a dataflow, the Power Query engine there has a more limited set of connectors and functions. If you are trying to connect to Azure DevOps (ADO) data using a connector or function like VSTS.Contents, it won’t work in dataflows because the service does not support this connector or function natively.
To resolve this, you might need to:
Use supported connectors in dataflows, such as the Azure DevOps Analytics connector if available.
If you require advanced API calls, use Power Query Web.Contents with proper REST API calls to Azure DevOps REST APIs instead of relying on a connector.
Consider moving the complex transformation steps to Power BI Desktop or Azure Data Factory, and then push a simpler data source to the dataflow.
Verify that all referenced functions are supported in Power BI Service for dataflows.
In summary, the error means that the function VSTS.Contents is not recognized in the dataflow environment, and you will need to adjust your query to use supported methods for connecting to Azure DevOps data within Power BI dataflows.
Hi @sravs2007 ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Not Solved.. stilll getting an error..looking for an alternative opiton.. since local refresh is taking more than 6 hours.. which is impossible.. to wait... so trying ot create Dataflow. but in Dataflow am getting above error
Hi @sravs2007 ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Hi @sravs2007 It might be throttling because VSTS.Contents isn't recognized in Power BI Service due to missing module support. This often occurs when a connector works in Power BI Desktop but isn't available for dataflows. Try loading the data in Power BI Desktop and publishing it as a dataset instead. Youcould also use REST APIs or export ADO data to a supported source like SQL.