Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Updating a Changing Data Source File Name

Hi all,   I have a client's web folder where daily .csv's are uploaded. The .csv files are identical in structure - all that changes is date at the beginning of the file name, which is always YYYYM...
Need Help
  • danextian's avatar
    danextian
    8 years ago

    Hi Anonymous,

     

    I highligted the part of the code you were missing.

     

     

    let
Source = Csv.Document(Web.Contents(
    let today = DateTime.Date(DateTime.LocalNow()) in
    "https://https://www.clientsite.com/" &  
    Number.ToText(Date.Year(today)) &
    Text.PadStart(Number.ToText(Date.Month(today)),2,"0") & 
    Text.PadStart(Number.ToText(Date.Day(today)),2,"0") & 
    "_users_per_country.csv"), [Delimiter=";", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", Int64.Type}})

in
#"Changed Type"

     

    The use  of the code is to replace your URL with something dynamic while the remaining parts of your Source variable remain untouched.

     

     

Jay7's avatar
Jay7
Frequent Visitor
8 years ago

You may not need this now. But just wanna add my two cents.

I used this one shot conversion

 

FileName = "(File Path)" & Date.ToText(Date.From(DateTime.LocalNow()), "YYYYMMDD") & ".csv"

 

Schedule refresh will not work as expected iin this situation as it keeps asking credentials for new file name.

 

Solution is given in the below link

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Unable-to-Refresh-Dynamicly-Generated-File-Name-Data-Source/m-p/451508/highlight/true

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks Jay7 - sadly (or maybe thankfully!) the dashboard this was being used for is now defunct! 

     

    Cheers anyhow!

     

    Sam