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

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

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: 255 members 2,795 guests
Please welcome our newest community members: