PowerQuery/M Code or R script within Power BI

[Iloveexcel&excelloveme]

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

 

[Ken Puls]

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/

 

[Iloveexcel&excelloveme]

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