import files based on file name in a folder

[Anonymous]

I have a large data set of various files all being placed in the same folder for example: 

Bounces_20220703.csv

Bounces_20220704.csv

Bounces_20220705.csv

Clicks_20220703.csv

Clicks_20220704.csv

Clicks_20220705.csv

Opens_20220703.csv

Opens_20220704.csv

Opens_20220705.csv

The folder will have a new file for each every day with the current date format YYYYMMDD after the file name

What I want to do is have all of the clicks collated together, all the opens and all the bounces, and when a refresh happens it combines the latest daily output. 

[Anonymous]

Three separate outputs if possible rather than combining them at this stage 

[Vijay_A_Verma · Accepted solution]

In Advanced Editor for Main Query, replace "C:\Test" with your path. Use the below pbix file to test.

https://1drv.ms/u/s!Akd5y6ruJhvhugSekEo72BRz9kUb?e=bMbsXj 

[Anonymous]

Hi,

Apologies are you able to send the code - as i am on my work laptop i still have an older version of Power Bi (cannot upgrade currently) so it wont let me open the file.

[Vijay_A_Verma]

Since you are importing files from a folder, it is not a single code. Here is Excel file (you should have Excel, I presume) and you can change the C:\Test in Main Query.

https://1drv.ms/x/s!Akd5y6ruJhvhugX4raY_byMCVthP?e=n5Vk5h 

[Anonymous]

Perfect thank you,

I will mark the original PowerBi one as the solution for people 

[Vijay_A_Verma]

Do you need 3 different outputs - one each for Bounces, Clicks, Opens OR a single output combining only 3 of these?