cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Pedzilla Member
Member

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 it gave me the following error message.
 
I can successfully refresh my dataset on desktop. Can you help? Thank you
 
 
Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'Microsoft.PowerBI.Scripting, Version=1.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A)'Hide details
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 25
Community Support Team
Community Support Team

Re: R script refresh with personal gateway - credential message

HI @Pedzilla,

 

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

Spoiler

R 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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Pedzilla Member
Member

Re: R script refresh with personal gateway - credential message

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 @v-shex-msft

 

output <- dataset

 

Pedzilla Member
Member

Re: R script refresh with personal gateway - credential message

@v-shex-msft in personal gateway I also switched of custom data connector as per some of previous posts who said this helped.

Unfortunately this didnt make any difference in my scenario.

tqbao27 Frequent Visitor
Frequent Visitor

Re: R script refresh with personal gateway - credential message

I also encountered the same problem. My R script was working fine with the Setptember version of personal gateway.

Community Support Team
Community Support Team

Re: R script refresh with personal gateway - credential message

Hi @Pedzilla,

 

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.

5.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Pedzilla1 Frequent Visitor
Frequent Visitor

Re: R script refresh with personal gateway - credential message

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 @v-shex-msft
Pedzilla Member
Member

Re: R script refresh with personal gateway - credential message

Is it possible you can share your pbix file so i can try it here please? @v-shex-msft 

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

 

Pedzilla Member
Member

Re: R script refresh with personal gateway - credential message

Hi did you find a workaround @tqbao27

Community Support Team
Community Support Team

Re: R script refresh with personal gateway - credential message

HI @Pedzilla,

 

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.

9.png

 

BTW, I also attached sample files which I tested at below.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 2,253 guests
Please welcome our newest community members: