Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

import multiple CSV files from sharepoint folder

Hi all!   First of all, I know this is maybe a rookie question but I am so new in power bi.   I need to create a dashboard with ServiceNow data, this data will generate a different CSV every week...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    Hello Anonymous ,

    It sounds like you're doing things the correct way... 

    Either way i'll show you with some pictures: 



    Navigate to the correct directory and then filter to make sure only the relevant files remain.

    Press the double arrow.

    Select which parameter you want to extract from each file.

    This should give you the data from all of the files combined in the following manner:


    Hope this helps, 
    J


tex628's avatar
tex628
Community Champion
6 years ago

Hello Anonymous ,

It sounds like you're doing things the correct way... 

Either way i'll show you with some pictures: 



Navigate to the correct directory and then filter to make sure only the relevant files remain.

Press the double arrow.

Select which parameter you want to extract from each file.

This should give you the data from all of the files combined in the following manner:


Hope this helps, 
J