Multi tables

[Rodrigo_Lauret]

So I am managing a big area of forest with multiple divisions and what i want to do is creat an interactive dashboard. 

The problem is i have in each excel sheet one operation and one year in a total of 30 excel sheets and i wanto to connect them all to see the data with the filters (operation, year, division). Thanks in advance if needed i can post where the tables.

[v-diye-msft]

Hi @Rodrigo_Lauret 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[amitchandak]

@Rodrigo_Lauret 

The first step would be to append if they are in the same format

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Also, refer:

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data