Forum Discussion

joekoshar's avatar
joekoshar
Regular Visitor
7 years ago
Solved

Excel Data Source Changing Daily

One of the my data sources is an Excel extract that is updated daily. The tail end of my extract includes the date of the extraction as well as a seemingly random number. I am hoping to update the da...
Need Help
  • BobBI's avatar
    BobBI
    7 years ago

    Hi,

     

    1. Place all your file in a consistent name format in one Folder

    2. Load power BI from Folder. GET DATA = Folder

    3. Split File Name to get Datetime value from file name

    4. Change data type to DATE or DATE Time for the column containing Datetime value .( you might have to change 10.19.18 to 19/10/18 date format.  if you have multiple file for each day consider time as well and data type to datetime.

    5.  if you have to load only latest file --> file date column = Is Latest

     

    Hope this helps,

    SS

BobBI's avatar
BobBI
Resolver III
7 years ago

Hi ,

 

1.Place all your file into One Folder

2. Load Power bi with Get Data = Folder

3. Edit query -> File Name and DateTime part

4. Make Date column as Date or DateTime Data type ( you may to replace 10.19.18 with 19/10/18 format) or change the file name

5. Filter date columns   Data Filter = Is Latest  ( This is alway load latest file ) if you want to load all file skip this step.

 

screenshots beloe for easy navigation reference.

 

 

 

Hope this helps,

SS