Forum Discussion
Invalid Credentials After Updating R Version
I have been unable to refresh any of my reports, due to invalid credentials ever since updating my version of R.
I get the following message:
The refreshes had all been working fine before upgrading my R version from 3.4.4 to 3.6.1. I made the corresponding change to the R home directory in my PBI Desktop (the pbix file wouldn't refresh without it) and then reuploaded the reports. Since then, refreshing their datasets with RDS files generated by the 3.6.1 version always causes the credentials problem.
Reverting back to the older R version (along with changing back the home directory and reuploading the reports) takes away the credentials problem, and things go back to behaving prior.
Is this really a limitation with respect to the R versions one can use?
Refreshing the data on the Desktop works fine, once you change the R home directory. It's the service that seems to have a problem with data generated by the newer version of R.
___________
Attempted solution:
I did some research and found this case:
https://community.powerbi.com/t5/Power-Query/Refresh-R-Scripts-with-Personal-Gateway/td-p/434177
However, upon checking my personal gateway already had custom data connectors switched off:
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.
9 Replies
- nickyvv
Most Valuable Professional
Hi,
it seems the current supported R runtime version is still 3.4.4. So upgrading won't work at this time I'm afraid.
Source: https://docs.microsoft.com/en-us/power-bi/service-r-packages-supportHi 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.- nickyvv
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?
