Entry Sheets - What would be the best approach

[misiek5510]

Hi Guys,

I'm looking for a best way to gather the data from 150 separate excel files which will have to be updated and read by power bi on weekly basis. The excel files will be either one or multi tab depending on a customer. For example if a customer is BBC and it has just one site in Berlin it will be one excel file with one tab "Berlin", and if its CNN and has two branches in London And Tokio it will be one excel file with two tabs for each Lonon and Tokio etc. Now what would be the best way to get data from all these 150 files which potentially are multi tab ? Would it be best to have like a master file in excel that reads them all and puts it in a table or would it be better to do it directly with powerbi?

 

[GraH]

Both approaches work. To answer which one is the best option... It depends on the situation.
Maybe having the data prepared up front makes the PowerBI solution faster.
On the other hand you have an additional step in your process.
I've read somewhere you might configure partial refreshes to speed things up in PowerBI. No clue however how that's done.

 

[XL Pro]

Hmm...maybe take a look at this scenario Multiple Worksheets From Multiple Workbooks