Forum Discussion
Formula.Firewall: Query references other queries, so it may not directly access a data source.
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
It's hard (for me) to tell without seeing it "properly" but there doesn't seem to be anything wrong.
The only thing I can say is that I now have ALL data loads in separate functions ... I added a function which gets passed a sheet/range name and it loads the data.
I see that you have Source=Twitterdata ... what is Twitterdata, it doesn't seem to be a function as it doesn't have () closing brackets.
Apart from that this is a simple script which I would have hand-coded as a single multi-line statement so I'm rather puzzled.
Hope you sort it out. Good luck.
Solved just using "Merge" as soon as possible on the query.
Seems that editor doesn't like to do merges by the end of the query as it was clearly explained on excelguru blog.
Josep.