PowerBI to act exactly the same for each Excell tab.

[Anonymous]

Hi , I hope I'll write this right. I have and excell sheet with 20 exactly the same tabs with metrics for diffrent teams. Short example of the columns:

Start date

End date

Status

Comments

Sprint

Started

Added tickets

Removed tickets

Change

Started SP

Added SP

Removed SP

Change SP

So based on that I want to create a PowerBI report with 20 tabs for each team. But I honestly don't want to do this manually so I really hope there's a way to automate this.

Thanks in advance.

[v-chuncz-msft]

@Anonymous 

You may take a look at Shape and combine multiple data sources.