Credentials for R in Power BI service

[Anonymous]

Hi, I have a requiremnt to export data from Power bI to an excel or csv on a regular schedule.

To acheive this, i have added a R script in the query editor in Power BI desktop and when i applied changes, the script executed and the data was exported to the file mentioned.

I have published the report to the service to schedule it. I have installed the personal gateway and no issues with the gateway.

But it says the credentials for 'R' are not valid. 

[v-diye-msft]

Hi @Anonymous 

It might be related to the .NET Framework. Please re-installed .NET framework and restarted the server for a test.

 Failed to find or load the registered .Net Framework Data Provider

and here is a simiar post for you as a reference.

[Anonymous · Accepted solution]

I have raised a support ticket with Microsoft, and they have asked to use April 2020 gateway, which fixed the problem.

Looks like may version of gateway is not supported for R.