Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Best Methods of Importing Data Into Power BI: Text/CSV vs Web?

Hi Friends,   I have a question about the best method to use to import Text/CSV files into Power BI. I have Power BI pro license. Power BI desktop has both Text/CSV and Web options to import data. ...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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?    

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

Yes.

 

Best Regards,

Bof