cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrew_armst
New Member

Presenting data from multiple tables

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

1 ACCEPTED SOLUTION
jairoaol
Super User
Super User

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

then if you perform the append process.

View solution in original post

5 REPLIES 5
jairoaol
Super User
Super User

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

then if you perform the append process.

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
Super User
Super User

@andrew_armst , You can use append in power query

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

 

 



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Cseneff
New Member

Hi Andrew,

 

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

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.

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors