Dynamically append new tabs from Excel Workbook source upon PBI refresh

[BrandonPruitt]

I hope the subject line explains it... i'm finding it hard to put into words what I am trying to do.

Basically, I have one excel workbook, lets call it "DataByWE.xls".  That workbook has a tab for every "Week", and the same structure of data is within each tab.

So, next week, when I go to update my data, I would create a new tab, name it accordingly, and "refresh".

Currently, I have to first add that new tab into PBI, manually, and then add it to the list of "appended" sources.

Is there a way to automate this... so when I 'refresh' it inspects the source xls file, sees that there's a new tab, and automatically adds it to the PBI?

[Anonymous]

Hi @BrandonPruitt ，

You can use Power Automate to automate the refresh process of adding a new tables to Power BI.
With these sorts of processes, users often expect Power BI reports to be updated as soon as they enter data in underlying systems. 

Please refer to

Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

Create a Power Automate visual for Power BI (preview) - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Idrissshatila]

Hello @BrandonPruitt ,

Yes, refer to this video https://youtu.be/x30ssa2K9gU?si=Kvb8Ys5BWfuvfgPU

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡