PowerQuery/M Code or R script within Power BI

Hi Everyone,

@Moderator, i hope this thread is not out of topic.

I've been a heavy user of PowerQuery to perform all my ETL before passing it onto PowerBI.

As i'm working with millions of rows of data, PowerQuery can get too slow whenever i edit anything as it will go through step by step.
Thus i'm wondering if R Script would be faster to perform the ETL within PowerBI instead of PowerQuery?

I'm also curious if anyone here uses R Script within PowerBI to clean up their data.

Cheers

Hey there,

Perfectly on topic I'd say. I'm honestly not sure about R, having never used it myself. But on the development lag, I totally hear you. I don't know if this will help, but it's a strategy that may be useful: https://www.excelguru.ca/blog/2017/07/20/reduce-development-lag/

Hi Ken Thanks for the reply and for writing "M is for Data Monkey", your book help me alot (Heard there a 2nd edition coming up this year )

I read the link before but haven't really try it yet. I'll give it a try again
As i'm exploring various Machine Learning package and etc within R with PowerBI thus i'm wondering if i do everything within R via PowerBI