Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Updating Excel Data Sources - Best Practices

Due to constraints outside of my control, I am unable to establish direct connections to the systems/data sources of much of my work. To get this data into Power BI, I rely on exporting to Excel and u...
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    You could try this way, Every time export the data to a new excel file, and put it in the same folder, then get data from folder.

    https://powerbi.tips/2016/06/loading-data-from-folder/

     

    By the way, in the blog.

    Click the drop down next to Name and sort the files in Sort Descending.

     

    You could also sort file by other file attributes e.g. date Modified/ Date created  in sort descending.

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous

You could try this way, Every time export the data to a new excel file, and put it in the same folder, then get data from folder.

https://powerbi.tips/2016/06/loading-data-from-folder/

 

By the way, in the blog.

Click the drop down next to Name and sort the files in Sort Descending.

 

You could also sort file by other file attributes e.g. date Modified/ Date created  in sort descending.

 

Best Regards,

Lin