Forum Discussion

shikhar237's avatar
shikhar237
Regular Visitor
8 years ago
Solved

connecting database

Hi all, I want to connect the data collected from my franchise stores and make a report out of it. If the franchise reply me the data in separate excel sheets, how can I club their data (rows) autom...
Need Help
Show and Tell
Tutorial Requests
  • shebr's avatar
    shebr
    8 years ago

    Hi shikhar237

     

    What you can do is place all the files in a single folder. In Power BI you can then use the get data from 'Folder' option. This will allow you to combine all the files in the folder and report on them as one data source.

     

    As you add more files to the folder, Power BI will pick these up when you 'Refresh' the data.

     

    It may be useful to make sure there is a column in the excel files that show the location of the files.

     

    Hope that help, let me know how you get on.

     

    Thanks

     

    shebr

shebr's avatar
shebr
Resolver III
8 years ago

Hi shikhar237

 

What you can do is place all the files in a single folder. In Power BI you can then use the get data from 'Folder' option. This will allow you to combine all the files in the folder and report on them as one data source.

 

As you add more files to the folder, Power BI will pick these up when you 'Refresh' the data.

 

It may be useful to make sure there is a column in the excel files that show the location of the files.

 

Hope that help, let me know how you get on.

 

Thanks

 

shebr

  • shikhar237's avatar
    shikhar237
    Regular Visitor
    8 years ago

    Thanks a lot shebr

    Your suggestion works nicely for me