Forum Discussion
R script refresh with personal gateway - credential message
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.
Your sample doesnt work when I tried on my personal gateway. I dont suppose we can change that can we?
Anonymous