Credentials for R in Power BI service

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.