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
Solved! Go to Solution.
each list creates a column with the name of the site to which they correspond.
then if you perform the append process.
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.
@andrew_armst , You can use append in power query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
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.
User | Count |
---|---|
135 | |
63 | |
57 | |
56 | |
46 |
User | Count |
---|---|
139 | |
65 | |
61 | |
60 | |
53 |