Daily data is updated by sheets in one Excel file. How to import and schedule update it in Power BI

[quizhyo]

Hi all,

We have an excel file to manage inventory. It file is a little bit complicated. So each day, we will record all data into 1 sheet, and create another sheet for the next day. 

Now, I cannot import it into Power BI (or scheduling update). Are you have any solution?

Best regards,

Hung

[amitchandak]

@quizhyo ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[quizhyo]

Excel sheet is 2 dimensiton data struture . So we have 
+ Row: Product grade
+ Column: Location of product in warehouse
Each day, all information will be updated one time, woker will create new sheet for new recored (Sheet name is the "date" which they update data )

Each sheet contains a table of data with rows representing product grades and columns representing locations, and each sheet represents a different date.
So, data will be not record in only one table, new data coresponding with new sheet.

So how to import data ?