Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Unable to Combine Data Refresh Error

We have a report that pulls multiple data sources from the web to get data on the US Congress (list of members, bills, etc.). To get a complete picture (i.e. a bill number and a bill name), I must me...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks. I was able to fix it by adding additional an additional conditional column in the query and then using RELATED DAX functions.  Not the most elegant situation, but it was the only way to get the correct data the way the client wanted it. Thanks for the replies! 

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 

 

What I have found to get this working is you have to have all the steps within a single table. As soon as they are in seperate tables you can start to run into issues as you have described.

 

This does get rather complex and can take some time to get it working.

 

Here is a blog post that might help: Power Query Errors: Please Rebuild This Data CombinationThe Excelguru Blog

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks. I was able to fix it by adding additional an additional conditional column in the query and then using RELATED DAX functions.  Not the most elegant situation, but it was the only way to get the correct data the way the client wanted it. Thanks for the replies!