Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vijaykumarj19
Employee
Employee

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 2
v-rongtiep-msft
Community Support
Community Support

Hi @vijaykumarj19 ,

There seems to be an error in the Removed Errors step. Please check the step in Applied Steps.

vpollymsft_0-1643855597830.png

 

I have also found some similar posts, please refer to see if they can help you.

https://community.powerbi.com/t5/Service/Unable-to-combine-data-Please-rebuild-this-data-combination...

https://community.powerbi.com/t5/Service/Refresh-problem-Unable-to-combine-data/m-p/1656989

  • put every stage used for the query into a single big query
  • refresing the data from Edit queries

 

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..

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors