Cant click edit Credentials R in PowerBI Services

[sontt]

Hi everyone,

I have problem when i reinstall windows and install Gateway Personal (ver 14.16.6650.1). Then now I cant click to Edit Credentials for Rscript in powerbi services, but other type (web, file, sql,..) i still can edit credentials.

Please help me how can i edit credentials for Rscript. Tks so much!

[sontt]

Hi @Anonymous,

Please help me :(. I dont know its Gateway error or my mistake. I tried any way:
+ Test on safari, chrome, IE, Edge,..

+ Used other PCs and install new PowerBI Desktop, Gateway Personal

+ Used other Accounts

+ Create other file use Rscript

+ Clear and add new permissions in PowerBI Desktop in Change sources setting,....

I tried test all cases but i still cant fix it.

My account is trial Pro users, then i cant send support ticket for Support Team.

Please help me test it on your account if u can. 

Thank u so much!

[sontt]

I tried click many times to other Edit Credentials, then i can click R Edit Credentials.

But now, i got other problem, i dont have anything authentication method. Then i cant Signin.

Anyone have same problem? Help me fix it please!

[Anonymous]

Hi @sontt.

I test with your sample file and I found you're use 'jsonlite' package. I have check on supported R packages in power bi sercice but haven't found it.

I think your issue may related to unsupported R package, maybe you can test with other packages.

R packages in the Power BI service 

BTW, I can config your test file's R script certificate.(windows without impersonation)

Regards,

Xiaoxin Sheng

[sontt]

Thanks for ur help sir. I tried other file test in Microsoft document: https://docs.microsoft.com/en-us/power-bi/desktop-r-in-query-editor

Link down: http://download.microsoft.com/download/F/8/A/F8AA9DC9-8545-4AAE-9305-27AD1D01DC03/Complete%20Values%...

But i cant fix it :(.

I have too many report used Rscript and i already set Schedule Refresh successful before and refreshed completed. Then now i cant used it, maybe i need wait for next gateway update.

Anw, thank u so much sir!

[sontt · Accepted solution]

Hi @Anonymous,

Finally, this bug got fixed and i can click Edit Credentials for Rscript. Anw, thanks for your help.

[Anonymous]

Hi @sontt,

>>Then now I cant click to Edit Credentials for Rscript in powerbi services, but other type (web, file, sql,..) i still can edit credentials.

Normally, your credentials need have permission to access/operate datasource device.

Did you have any other operations in R script? Which datasource you used for r script?
Please share more detail contents to help us clarify your scenario.

Regards,

Xiaoxin Sheng

[sontt]

Hi @Anonymous,

I tried test edit in 2 others PCs, with 2 other accounts and try create test file. But I still cant click Edit Permission for Rscript. I think because i upgrade gateway personal to newest version.

This is my Test file, please help me check it.

https://drive.google.com/open?id=1P6avz8a6oC-0w8PLzc0eqL59VWuZBO6-

Thanks for your help!