Ryan Wade argues that R is a better language choice for working with data in Power BI than M:
Now let’s do something that I think is pretty slick. Let’s create a data set that combines the home games of the Pacers (IND) and the home games of the Hawks (ATL). Given the naming convention used by the files we will have to identify the files in our working directory that starts with an eight numeric digits > then a period > then a 3 character team abbreviation for the away team > then either “ATL” or “IND” > then finally “.csv”. We can create a regular expression to find the files that matches that pattern. I did so in the code below:
I’m interested in catching the rest of the series. This is a controversial statement that I’m not entirely sold on yet, but Ryan does set the stage for his full argument.