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
Super UserAnonymous ,
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
Thanks Kedar_Pande for your informative answer.
If the report is fetching data in my local drive, it seems I cannot set up data auto-refresh for the data/model. Nor can another other member in the workspace.
- Kedar_Pande
For that, you will need to set up a Power BI data Gateway.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem