Forum Discussion
Refresh R Scripts with Personal Gateway
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.
the problem still exists. here is the steps to reproduce the issue.
Interestingly, I can set up personal gateway to refresh python script without an issue. so this is probabaly an issue particularly with R.
in app.powerbi.com settings > datasets > edit credentials > authentication method : windowswithout impersonation (which is the only option) > privacy level: public > sign in > then throws error:
Failed to update data source credentials: Exception of type 'Microsoft.Analytics.Modules.R.ErrorHandling.RException.Primitives.NotValidRDataException' was thrown.
| Activity ID: | 27de3ae3-c2eb-4264-84d8-9600f0a5a4c0 |
| Request ID: | d817f2d5-4124-4300-a997-3476d637cc42 |
| Status code: | 400 |
| Time: | Thu Aug 01 2019 22:23:27 GMT+0800 (Hong Kong Standard Time) |
| Version: | 13.0.10246.182 |
| Cluster URI: | https://wabi-east-asia-a-primary-redirect.analysis.windows.net |