Forum Discussion
Need help with R script
- 8 years ago
Ok, looks like the merge is the issue not the r
KenPulshas blogged about the "Rebuild This Data Combination" Error.
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
Also discussed here
I rebuild the query according to KenPuls blog but still got the error.
Then I changed the the Privacy for the file to Ignore the privacy levels and it worked.
I not sure that is the right way to do this but ontil there is another solution this most do it for now.
Thank for your help stretcharm
So turning off Privacy does a couple of things:
- It will ignore the error
- It will (most likely) speed up performance
The issue is that it no longer checks to make sure the data sources are safe to combine without leaking data. If all my data is in the organization, I usually turn this setting off, but you do want to be careful of just doing that as a blanket answer.