Forum Discussion
Using R script in Power Query - Error associated with factor level recognition
It would appear that the problem was due to a space being entered at the end of "Factor A ". Trimming white space solved the problem. Of course, now I have another problem, but I'll put that in another thread.
Thanks for responding, amitchandak!
I assume you mean the R packages. Yes, all necessary packages are installed and loaded. In any case, the function causing problems is from base R, not a package. As I mentioned, the script works just fine when used through the Get Data > R script pathway. It does not work when I use it to transform the original Excel file in Power BI's Power Query.
It would appear that the problem was due to a space being entered at the end of "Factor A ". Trimming white space solved the problem. Of course, now I have another problem, but I'll put that in another thread.