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


Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

As far as I know. SharePoint folder is currently the only and best way of importing multiple files. You can read this article to check details of shaping the data in power query.

Best,
Paul

trebgatte's avatar
trebgatte
Most Valuable Professional
6 years ago

I published this blog post today on how to do the merge process. https://marqueeinsights.com/how-to-merge-multiple-excel-files-with-power-bi/ That might be helpful.

 

Also note, we have a Power BI commercial solution that works with ServiceNow directly, without the CSV downloads. Send me a direct message if this is potentially of interest.

 

Hope this helps!

--Treb, Power BI MVP