Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

R script refresh with personal gateway - credential message

Hi, I just downloaded and installed personal gateway. Tried to schedule refresh My data source is R. The only option Ive got is WindowsWithoutImpersonation - which I clicked on Sign In button and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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