Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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,
Mélissa
HI @Anonymous,
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.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
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,
Regards,
Mélissa
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!