R dataset read in Power query

[Ahamidi180cc]

Hi everyone,

We're trying to export a huge dataset of over 500000 rows to multiple CSV files using an R script in Power query. The script works but the problem we're facing is that R seems to only read the data of the power query preview. Because of this our CSV files are not complete. 

Is there a way that R reads the entire dataset in Power query instead of just the preview?

Kind Regards ,

Ahamidi180cc

[lbendlin · Accepted solution]

Let Source = Table.Buffer(Accounts),

[Icey]

Hi @Ahamidi180cc ,

Please let us know if @lbendlin's reply is helpful.

If it is, please always accept his reply as solution to your question so that people who may have the same question can get the solution directly.

If not, please give us more details.

Best Regards,

Icey

[lbendlin]

Use a Table.Buffer transform before running the R script.  That should load the entire data.

May I ask why you abuse Power Query and R in such a manner? Have you thought about using proper ETL tools like Alteryx?

[Ahamidi180cc]

Hey Ibendlin, 

The table.Buffer didnt really work. Where exactly do you put the Table.Buffer command? 

Kind Regards