Use parameter that contains a current date formula at the data source

Asked

Viewed 90 times

1

I get extraction files from the database in . csv format with default:

C://director_staff/CSV_01-01-2019/file.csv

A new folder is created every day, so to automate this in power BI, in the orgiem of the data I made the command below:

= Csv.Document(File.Contents(pCaminho & DateTime.ToText(DateTime.LocalNow(), "dd-MM-yyyy") & "\2_areas_tematicas.csv"),[Delimiter="#(tab)", Columns=6, Encoding=65001, QuoteStyle=QuoteStyle.None])

I would like to put this whole date command in a parameter, just like I did with the directory footpath, but he won’t accept:

inserir a descrição da imagem aqui

Anyone who can help, I’d be most grateful.

  • I believe it’s because of the quotation marks.

  • Breno, I removed/changed the quotation marks. It didn’t work

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.