topic Re: Export Table via R script (Power Query) in Developer

Export Table via R script (Power Query)

Gozde — Thu, 01 Jun 2017 12:29:38 GMT

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

Re: Export Table via R script (Power Query)

v-sihou-msft — Fri, 02 Jun 2017 09:16:12 GMT

@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,

Re: Export Table via R script (Power Query)

Gozde — Fri, 02 Jun 2017 09:37:33 GMT

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