Forum Discussion
Invalid Credentials After Updating R Version
v-xuding-msft
Hi, thanks again for the reply and advice. Really appreciate the follow up effort. Perhaps the support ticket might help.The meantime workaround solution I've gone with was to move down to R 3.5.1. It works just as fine as 3.4.4 has with me, and I'm able to use certain packages 3.4.4 can't.
Hi nickyvv ,
Thank you so much, really appreciate the reply. However, reading through the link, I think that 3.4.4 limitation is for using R to create visuals. None of my visuals are generated by R scripts. Instead, I'm just using R to 'Get Data', i.e. generate data tables or load them into the report from RDS files.
A colleague of mine is able to refresh her reports no problem using R 3.5.1. So, I'm not sure that I'm necessarily stuck with 3.4.4 per se.
Ok, that is indeed a correct observation :-)
To further clarify, are you using:
- Get Data > R script?
- Query Editor > Run R script as a Power Query step?
And is this working in your local Power BI Desktop?
I'm using Get Data > R script on my local Power BI Desktop.
I simply use the R script to load data from an RDS file already generated (via RStudio).
After upgrading my R version, I had to change the R home directory in order for the report to load data from RDS files generated by the newer R version. This works fine, but refreshing the report after it's uploaded in the PBI service does not (I get the credentials error).Hi josen95 ,
Please clear the global permission and re-connect to the data source. And try to refresh manually in Desktop to check if it works fine. Then republish the report to service.
Moreover, make sure that you install the latest version (3000.10.232) of gateway and the latest version (2.74.5619.841) of Power BI Desktop.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hi v-xuding-msft
Thank you very much for the reply. Really appreciate your effort.I did as you said: cleared the global permission then reconnected to the data source. I started a manual refresh on the Desktop, which worked fine (as it has been, ever since changing the R home directory), and republished. However, once again it was attempting to refresh the dataset in the service after republishing the report that failed - same credentials error.
Refreshing in the Desktop works fine as long as R home directory is the updated version as well. Unfortunately, refreshing in the PBI service causes the credentials error.
