Forum Discussion

van_r's avatar
van_r
Frequent Visitor
4 years ago
Solved

How to split files sourced from an folder

I have a dashboard that uses about 10 different CSVs as data sources. Each CSV is a different type of report--meaning, these are not different versions of the same report. Currently, I've loaded each...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  van_r ,

     

    When you connect to a folder and get a window as below:

     

    Click Edit,go to query editor and select the file you need by filtering the name column.

     

    Finally get the content of the file by expanding "Content" column:

    For details,you could check below:

    https://powerbi.tips/2016/06/loading-data-from-folder/

     

    Duplicate table and repeat the above steps to get all the needed files.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

     

     

parry2k's avatar
parry2k
Super User
4 years ago

van_r does each csv has the same structure? Even though you need 10 tables, but if each csv is the same structure, then keep the file name as part of the dataset and have one table, and the user can use filename as an identifier to filter the data for the specific file.

van_r's avatar
van_r
Frequent Visitor
4 years ago

No totally different file structures