Presenting data from multiple tables

[andrew_armst]

Hi all,

I am new to powerBI to please forgive my ignorance or bad explination.  

We have 6 identical sharepoint lists that we want to combine into a PowerBI dashboard.  We have one list per company location that records: dates, names, status (absent/returned), comments etc. Every list is identical just the data in the fields differs.

I want to be able for example to display the Status of the staff as a whole corporation but then filter down into each individual site.  Problem is, I have no idea how to do this.  I can combine the tables into a new table but then I am unable to filter by site. 

Any help would be greatly appreciated.

Thanks,

Andrew

[jairoaol · Accepted solution]

each list creates a column with the name of the site to which they correspond.

then if you perform the append process.

[andrew_armst]

The lists generated a column that contained no data, I transformed the data in this column to contain the site name. I did this for every list. After that as you said, it was a simple case of then combining the data and filtering as I saw fit.

[amitchandak]

@andrew_armst , You can use append in power query

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

[Cseneff]

Hi Andrew,

Could you combine all the tables then add a new column that ID's the site?

[andrew_armst]

I thought about trying that, but the data is constantly being added too.  I didn't know if the new records would fill in the new column.  I could amend the form and lists to incliude the sites.   But if there is a way of doing this via power BI then I would rather do that.

I should note I have combined the tables into one table to test out an overall corporation view.