Forum Discussion

LincolnSantiago's avatar
LincolnSantiago
Frequent Visitor
8 years ago
Solved

Refresh R Scripts with Personal Gateway

Hi,   I'm using the R script to handle a pdf dataset in the Power BI Desktop query editor. But I can't make an schedule refresh from the R data source using the personal gateway in the Power BI Ser...
Need Help
  • LincolnSantiago's avatar
    LincolnSantiago
    8 years ago

    Hello everyone,

     

    I'm very happy to report that I received an answer from the Microsoft.

     

    Seems to be a known issue with the Personal Gateway. In the meantime, we have a workaround available as below:

     

    1. Open the On-premises Data Gateway (personal mode) desktop app on the machine where the gateway is installed.

    2. Go to the connectors tab and switch off the Custom data connectors feature.

    3. Click Apply -> Apply & Restart.

    4. On the dataset page, click edit credentials and sign in.

    Very good.

LY18's avatar
LY18
Icon for Helper I rankHelper I
6 years ago

I have the exact same issue

 

gateway version 3000.10.232

 

same message when i try to edit the credential foir the R script ....

 

if someone found a solution i'm really interested

 

regards

Anup's avatar
Anup
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

I have the same issue and it was occuring with the latest version of R script (3.6.1 ) and got fixed after using the lower version of R script (3.5.0).
Now we can successfully sign in to the R script (under data source credentials for Personal gateway  ) and refresh the r scripts dataset in Power BI service. 


Please mark this as solution, if this helps you !!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have the same issue with the older version of R.

    I also disabled the custom data connectors in the gateway settings. nothing helped.

    Any other work arounds or solutions? appreciate your help