Forum Discussion
Formula.Firewall: Query references other queries, so it may not directly access a data source.
I was able to find the solution. I aggregate the columns in my staging table and it had no issues.
Resident RockstarHi Anonymous,
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
In addition, you could refer to this two similar threads which has been solved.
Best Regards,
Cherry
I have read through everything you sent and I am still not understanding the issue. I have a staging table for the variables I am trying to pass into the function to give me the values. What am I missing?
- v-piga-msft
Hi Anonymous,
What's the kind of passing source? So that I can have a test to reproduce your scenario to research for this issue.
Best Regards,
Cherry
I was able to find the solution. I aggregate the columns in my staging table and it had no issues.
- v-piga-msft
Hi Anonymous,
It's glad that you have solved your problem.
Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry