Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
30 | |
24 | |
23 | |
20 |
User | Count |
---|---|
55 | |
34 | |
23 | |
22 | |
20 |