Forum Discussion

vijaykumarj19's avatar
vijaykumarj19
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Unable to combine data, please rebuild this data combination.

Context:

Bringing pull request data from azure DevOps repos.

 

Error:  [Unable to combine data] Section1/Repos (2)/Removed Errors references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Repos (2).

 

 

Query: 

let
Source = Repos,
#"Added Custom" = Table.AddColumn(Source, "Custom", each VSTS.Contents("https://dev.azure.com/" & Organization & "/" & [ProjectName] & "/_apis/git/repositories/" & [RepositoryId] &"/pullrequests?searchCriteria.includeLinks=true&searchCriteria.status=all&$top=100&api-version=6.0")),
#"Removed Errors" = Table.RemoveRowsWithErrors(#"Added Custom", {"Custom"})
in
#"Removed Errors"

 

Refresh is working fine in Desktop but throwing error in service

2 Replies