dynamically import files from a folder WITHOUT combining them

Hi @Imke,

Here is the message > \

Hi I am new to Power BI and I am facing an issue.

I have a Folder of csv files which I have to import. The csv files has readings of a electronic device,

I imported the csv folder and I got such a screen

Then I tried to remove the unwanted columns

now I have a column that shows the sourse file that is in my case the csv file for eg-MFT_RB1_2017-08-08_11-26-56.csv

I am getting all the data i.e the combined data of over 100 csv file in one sigle table as shown above. I want to create diffrent tables for each csv files. I can do it manually by importing csv files seperately like this -

 But when I am importing a folder I am getting a sigle combined table, I want to split the main table into tables=number of csv files and visualiye the output as above

(I got the above visualization by importing 6 csv one by one, which works perfect)

But when importing a complete folder I am getting one big table with all 100 csv combined and I want to create diffrent tables for diffrent csv like I did with the above visualization.

Also, I have over 100 csv files in the folder and if I add 50 more in the folder it should automatically create tables of those newly added csv files.

Can anyone help me with this?