cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Melissa_44 Regular Visitor
Regular Visitor

R script data source - sharepoint - schedule refresh

Hello,

 

I am using a R script as a data source, and in my R script, I import an excel file which is located in a sharepoint, and after I do some data management, so the easiest solution for me was to do this data management in R and import the correct data afterwards.

I am now confused about the schedule of the refresh data in this specific case:

- some people say it is not yet available

- some others say that the only way is via a personal gateway.

 

So which solution is the correct one? and if it is not (or not yet) possible, what are the alternative solutions to get this refresh schedule while having a R script as a source?

 

Thanks,

Mélissa

 

 

 

personal gateway

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: R script data source - sharepoint - schedule refresh

Hi @Melissa_44,

 

That's true.

 

Regards,

Frank

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

Re: R script data source - sharepoint - schedule refresh

Hi @Melissa_44,

 

Enable scheduled refresh for the dataset - to enable scheduled refresh for the workbook that contains your dataset with R scripts, see Configuring scheduled refresh, which also includes information about Personal Gateway.

 

Install the Personal Gateway - you need a Personal Gateway installed on the machine where the file is located, and where R is installed; the Power BI service must access that workbook and re-render any updated visuals. You can get more information on how to install and configure Personal Gateway.

 

Regards,

Frank

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

Re: R script data source - sharepoint - schedule refresh

Hi @v-frfei-msft,

 

Thanks for your answer,

I think i understood that i need a personal gateway, but I want to have a precision:

my workbook that contains my dataset within my R script is located into a onedrive/sharepoint and therefore not on my personal machine, does it make a difference, or do I still need a personal gateway?

I guess because of the source is a R script i need a personal gateway (R is installed on my machine) ?

 

Thanks for your insights,

Regards,

Mélissa

 

Community Support Team
Community Support Team

Re: R script data source - sharepoint - schedule refresh

Hi @Melissa_44,

 

In you scenario, the gateway is not required.

 

Regards,

Frank

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

Re: R script data source - sharepoint - schedule refresh

Thanks for your prompt answer,

May I ask for precisions:

- for a R script as source of data, there is a need of a personal gateway where the excel file that is read and manipulated is locally in my machine ?

and so in my case, because the excel file is located in a sharepoint I do not need one and I can use the same process to schedule data refresh as if I was using a csv or excel file in a sharepoint source, am I right?

 

Sorry, my question can sound very picky, but since I will have to do it plenty of times, I need to understand exactly what I need to do.

 

Thanks and regards,

Mélissa

Community Support Team
Community Support Team

Re: R script data source - sharepoint - schedule refresh

Hi @Melissa_44,

 

That's true.

 

Regards,

Frank

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

Re: R script data source - sharepoint - schedule refresh

Thanks @v-frfei-msft!

 

 

Regards,

Mélissa

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 164 members 1,951 guests
Please welcome our newest community members: