How can I set Power BI to pick the latest created file from a directory?

[UsePowerBI]

Hello

I want to specify a source (e.g. sharepoint website or folder or anything else) and I want Power BI to pick the latest created file from that directory.

How can I do that?

Thanks!

[edhans · Accepted solution]

When you are looking at the files befoe you select one, filter on the Date Created or Date Modified field, whichever is most relevent to you, and filter by Date, Is Latest. This is what I see when working through a SharePoint folder.

When you put a new file in there, that file will then become the latest and selected next time Power BI refreshes data.

[UsePowerBI]

@edhans thanks, can you tell me please where do I see that info in your screenshot? 

[edhans]

It is after you connect to the files in SharePoint (my example) but before you press the combine button. Is that what you are referring to @UsePowerBI 

[UsePowerBI]

@edhans thanks but what is the 'combine' button? When I import a sharepoint url, it shows the files and let's me choose which one to load or transform. What should I do next?

[edhans]

The combine button will open and process multiple files at once. The files must have the same structure, so 12 CSV files that are monthly sales data, one month per file, or 3 Excel files that have one year of data each, for 3 years total. If the file formats/structures are different, you need to connect one file at a time and do transformations specific to each file. Is that the question you are asking @UsePowerBI ?

[UsePowerBI]

@edhans Yes thanks! I didn't know that at all.