Forum Discussion

josen95's avatar
josen95
Frequent Visitor
6 years ago
Solved

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 ...
Need Help
  • josen95's avatar
    josen95
    6 years ago

    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.


josen95's avatar
josen95
Frequent Visitor
6 years ago

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.

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    6 years ago

    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?

    • josen95's avatar
      josen95
      Frequent Visitor
      6 years ago

      nickyvv 

       

      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). 


      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        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. 

        2.PNG

        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.