Forum Discussion
Best Methods of Importing Data Into Power BI: Text/CSV vs Web?
Anonymous ,
Using File.Contents fetches data from your local drive, which is good for personal use but won't be accessible to others if they need to refresh the dataset.
Using Web.Contents (SharePoint) is better for shared work. It ensures the data is always up-to-date and accessible by others without needing your local file, making it the recommended approach for collaboration.If this helped, a Kudos đź‘Ť or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande
Hi Anonymous ,
Both methods retrieve data from CSV files, with the main difference being the file's storage location—one is local, and the other is in the cloud. From the perspective of report users, there is no noticeable difference. However, if there is a need to refresh the data in the future, the semantic model that retrieves data locally will still require a gateway to be installed locally.
Best Regards,
Bof
Thanks, Anonymous . I do find that I cannot set up auto-refresh in the workspace with setting up a loca gateway connection, which I find challenging. Suppose I do get the local gateway up and running, does that mean my laptop needs to be always on and online, otherwise the data won't be refreshed?
Hi Anonymous ,
Yes.
Best Regards,
Bof