connecting database

[shikhar237]

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) automatically so that it gets reflected in my report/ dashboard. ( excel file has common column headers)
I want to avoid SQL as franchise don't use it. So if apart from excel file, if you have any knowledge of how to do the same with a different database, then please suggest.
Thank You

[shebr · Accepted solution]

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]

Thanks a lot @shebr

Your suggestion works nicely for me