Automatically update PowerBI file from Excel sheet

Hi Anonymous 

As tested, if you have an excel with mant tabs (week10....), then import this excel into Power BI,

each tab is considered as a single table to import into Power BI.

When you add a new tab in excel, to update this into Power BI, you need to connect this tab with Power BI again.

Also, since each tab is a single table in Power BI, we are unable to do a transformation for all tables all the time.

For example, yesterday, i have week10,week11,week12 tables, then i append the three table, 

today, i add a new table week13, i need to re-append these four tables again.

For the reasons above, i would like to suggest you to keep all weeks' data in a excel tab,  then connect this excel with Power BI.

Each time, you add new weeks' data in the excel, once clicking on the "refresh" button in Power BI Desktop, the new data will be updated.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.