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

R script data source: difference between source code and explicit code?

Hi all,


In the R script get data, is there a difference between:

- putting the code explicitely 

- source of the code (and the code can be either in local or in a sharepoint)


I was thinking that if there are some differences it is when refreshing the data source, but i do not know ?

Any insights on that?


Thanks and Regards,


Community Support Team
Community Support Team

Re: R script data source: difference between source code and explicit code?

HI @Melissa_44,


Actually, I think they are different source types, one is r script the other is file from local or sharepoint. When you use on second methods, you need a gateway to handle refresh of file datasource.



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: | |
Melissa_44 Regular Visitor
Regular Visitor

Re: R script data source: difference between source code and explicit code?

Hi @v-shex-msft,


Thanks for your answer but for the two cases I elicited I was thinking of the same source type: R script.

But in one case I write the code explicitely

and in the other case I write only 1 line of code which is source("https//sharepoint/.../prog.r").



What you are saying is that when a R script is the source of the data, then I need a personal gateway, is that right?

So, if this is true, then there is no differences between my two methods in terms of schedule refresh?


Thanks for your insights,





Helpful resources

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.

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