The purpose of this article is to demonstrate how to use an R script to load and prepare data source in Power BI desktop. R is open source powerful statistical analysis and visualisation language. Integrating R in Power BI lets you undertake complex data manipulation tasks. In this post I am going to use two sample csv dataset that contains raw data for import and export amounts for various Australian territories, and using R transform it to right format to be visualised in Power BI desktop. I am only going to cover basics of R to get data into the shape required so that you can use more interesting features of R in future.
Read more...