Forum Discussion
R script refresh with personal gateway - credential message
I just downloaded and installed personal gateway. Tried to schedule refresh
| Activity ID: | 9313b16c-78f0-4268-9f74-0905e78ab55a |
| Request ID: | 74961647-e14d-433c-c9c5-082010460226 |
| Status code: | 400 |
| Time: | Sun Dec 30 2018 16:15:39 GMT+0000 (GMT Standard Time) |
| Version: | 13.0.7683.237 |
| Cluster URI: | https://wabi-north-europe-redirect.analysis.windows.net |
25 Replies
I think the problem might have to do with mash up data source. I got my data from Oracle database then transform it using R script. Then Power BI might be asking for the credential of my Oracle database while I'm supplying it with R credential. I remember there used to be more option for authentication method. Not sure why there is only one option now. Anonymous
- I got no other data source in my test file, it pulls data from R script only. I doubt if it’s the mash up process for me?
HI Anonymous,
Can you please provide some detail information about this? (e.g. part of script code, local gateway refresh log..)
In addition, did any formula reference external data source in r script? If this is a case, current power bi service not support this, you can take a look at following link to know more about this:
Creating R visuals in the Power BI service
SpoilerR scripts security
R visuals are created from R scripts, which could potentially contain code with security or privacy risks.
These risks mainly exist in the authoring phase when the script author run the script on their own computer.
The Power BI service applies a sandbox technology to protect users and the service from security risks.
This sandbox approach imposes some restrictions on the R scripts running in the Power BI service, such as accessing the Internet, or accessing to other resources that are not required to create the R visual.
Regards,
Xiaoxin Sheng
Hi there, There is no custom visual in it. I use R script in the transformation. I simply loaded a local csv fle and use R script to rename the output from dataset to output. I apprecited that this isnt meaningful script but I want to proove that I can schedule refresh using personal gateway with R script.
Hope you can help me.
Many thanks Anonymous
output <- dataset
I also encountered the same problem. My R script was working fine with the Setptember version of personal gateway.
Hi did you find a workaround tqbao27
- Can you please give me your r script sample file and I will run in on my personal gateway.
My sample isn’t meaningful as it’s jusf a prof of concept that it can work on the gateway
Much appreciated many thanks Anonymous Is it possible you can share your pbix file so i can try it here please? Anonymous
Also what is the version of your gateway?
I wont be able to share my file due to network / firewall.
However its a generic dataset - here is the M code - hope you can help.
let
Source = R.Execute("cars = data(mtcars)#(lf)mtcars$date = Sys.time()"),
mtcars1 = Source{[Name="mtcars"]}[Value],
#"Changed Type" = Table.TransformColumnTypes(mtcars1,{{"date", type time}})
in
#"Changed Type"Thank you so much
HI Anonymous,
I test with my sample and your code, they all works well.
I think this issue may relate to data region service of power bi, maybe you can try to use fiddler to trace these httprequests of refresh operation.
BTW, I also attached sample files which I tested at below.
Regards,
Xiaoxin Sheng
I haven't found any work around yet Anonymous
Is there any way that I could download the old version of personal gateway Anonymous
We are having a similar issue on my team.
When attempting to provide the R credentials on the powerBI site, the I get the same error as op.
However, when I setup a personal gateway on my laptop that I use for work everyday, everything works fine!
I clicked the 'edit credentials' used the default only option of 'WindowsWithoutImpersonation' and set up an auto refresh and it all worked...
I then tried to replicate this on another system to free up my laptop, but and I ended up with the same error as before.
I can only get this working on my personal laptop.
On all three systems, I'm running:
R 3.5.1
Personal Gateway 3000.0.265
Hey Pedzilla,
Im glad to hear you got it working!
You rolled back to September release of R or PowerBI Personal Gateway?
