Export Table via R script (Power Query)

[Gozde]

Hello,

I am working on a report. I should get some data export from Power Query via R script.

I am using a code of write.table.

But, I am getting error: DataSource.Error: ADO.NET: R script error.

Can you help me with a sample code for csv or xlsx?

Thank you!

Gozde

[v-sihou-msft · Accepted solution]

@Gozde

You should do it in R visual to execute your "export data" R script. Make your install proper packages and assign permission to those packages on file. For more details, please refer to article below:

Export dataset into a file from Power BI Desktop using R script

Regards,

[Gozde]

Thank you very much 🙂

It solved my problem! I already installed the packages and R. However I should go Power BI instead of power Query and my directory was totaly wrong!

Best regards,

Gozde