It would be great if we could use Power BI to prepare the data that we want to feed into the R script. So a driver that R can use or ...?
It may be worth learning R and how to manipulate and clean data. Try the tidyR and dplyR packages for anyone with SQL experience.
