Forum Discussion
R script refresh with personal gateway - credential message
Hi Anonymous,
Can you please share a pbix file with some simple data and r script who can reproduce that scenario?
I will test on my side and report to power bi team if I can reproduce this issue.
BTW, I can use personal gateway to refresh r script sample file.
Regards,
Xiaoxin Sheng
- 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
Hey there I am based in the UK. Can I actually change the region on my personal gateway?
Anonymous
I will try your sample now.
