Forum Discussion

cdok1091's avatar
cdok1091
Advocate II
9 years ago

dynamically import files from a folder WITHOUT combining them

Hi all, I'm looking to upload multiple files of the same type from a single folder into Power BI Desktop.  However, in this case, I don't want to combine them into a single query.  How can I dynamic...
Need Help
ImkeF's avatar
ImkeF
Community Champion
8 years ago

Hi ajuanto,

this is the error-message I'm getting when trying to open the link you've posted:

So please post link that can be accessed publicly, thanks.

  • ajuanto's avatar
    ajuanto
    Frequent Visitor
    8 years ago

    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?