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! 

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Anonymous 

 

You need to combine all the queries into one query to work properly. In your case, you need to combine the query of the custom function Unzip into the main query.


You can refer to these two posts to combine your queries.

[unable to combine data] Please rebuild this data combination - Invoking custom function

Unable to combine data...AutoRemovedColumns1...Please rebuild this data combination

 

 

See the links below for more information:

Formula.Firewall: Query references other queries, so it may not directly access a data source.

[Unable to combine data] accessing data sources that have privacy levels

Power Query Errors: Please Rebuild This Data Combination

 

 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!