Power BI: How to import weekly data?

[niyati_61]

Hi all,

Currently I'm builing a Power BI Report for Engineering Progress Report data.

Regarding the Data: I get 5 Relevant Engineering Excel Files weekly. This Engineering data gets updated every week on Friday.

Now, the thing is from each of these Excel files I only need some tables or relevant information.

Eg: From Excel File 1: I need only 4 tables (and the other data (Many sheets) in the file is not required), and similarly with the other 4 Excel Files too.

How do I go ahead with data importing in my Power BI File? I mean do I have to always take it from the 5 separate Excel files manually? Or should I create one main Excel File by myself? How do I automate this process?

I would like my Power BI Report to be refreshed automatically when I receive the data every week as well.

Kindly request support on the matter. Thank you!

[amitchandak]

@niyati_61 , One of the ways is to have separate excel in a separate folder and configure folder load.

Also need to explore -https://wkrzywiec.medium.com/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4b...

Can give details like how many excel, each excel how many sheets are used etc