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 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

  • joekoshar's avatar
    joekoshar
    Regular Visitor
    7 years ago

    how can I import data from this file now that I have the dynamic file path? I thought about setting it as a parameter, but I am not sure if this is possible.