PDA

View Full Version : Please Rebuild This Data Combination - with R programming



julesp
2020-09-01, 03:58 PM
Hi all,
I'm trying to merge (but in a more complicated way matching strings) two dataframes in PowerBI using an R script. When I set the privacy settings to ignore, it can run, but otherwise, there are issues with the error on rebuilding the data combination due to not being able to reference other queries.

I tried to follow this blog post - https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ - but nothing has worked. One question for me to troublesheet... would I be doing this duplicating on the same query from which I'm running the R code? (Does it matter?) And does the R code run on the query that is to be duplicated? I just want to make sure that I'm doing everything in the right order.

Otherwise, once I confirm that I'm doing everything right and I have more issues, I'm sure that I will come back with more.