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!

     

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
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!