Forum Discussion
How can I avoid error - [Unable to combine data]...references other queries or steps...Please rebuil
Hi there, 2 weeks now i've been battling with this issue but can't find anything that will work despite multiple methods and workarounds. I have a report that began life as a pbix. Worked fine when...
lbendlin Hi
Thanks I will take a look. However, athought the error message is similar, the first two words 'Formula Firewall' to not appear in the message so i am not sure but possibly won't be an issue relating to this.
I am very sure that it is related. Have experienced it many times myself. All queries need to run in the same partition.
Hi lbendlin do you mean to consolidate all the M code into a single query?
I did it but it gave me the error. And I'm confused because in this article, this guy is suggesting actually do the opposite and segment components of the query. I tried it too but still didn't work.
Power Query Errors: Please Rebuild This Data CombinationThe Excelguru Blog
