Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Impactful Individual
Impactful Individual

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
Impactful Individual
Impactful Individual

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

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.