Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Hi @vijaykumarj19 ,
There seems to be an error in the Removed Errors step. Please check the step in Applied Steps.
I have also found some similar posts, please refer to see if they can help you.
https://community.powerbi.com/t5/Service/Refresh-problem-Unable-to-combine-data/m-p/1656989
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tried but throwing same error..
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |