Forum Discussion
Resolver IIIHow to link the Task table of multiple Sharepoint Task Lists
Hi
I hope someone can help.
I have a number of task lists designed for different teams to record what they are working on. Each list generates a unique task ID number per line. All of the lists are in the same PWA site.
What i would like to do is link all of the Task tables from all of the lists so we see, in BI, a consolidated table with all that information in, is this possible?
Thanks for your help
Matt
hi, Matt22365
What you want "merge" should be append function.
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Best Regards,
Lin
8 Replies
v-lili6-msftCommunity Support
hi, Matt22365
If you want this: import all Sharepoint Task Lists, then create the relationship with consolidated table,
and then use RLS to for different teams.
https://docs.microsoft.com/en-us/power-bi/desktop-rls
Best Regards,
Lin
Matt22365Hi v-lili6-msft
Thanks for your reponse, however this still requires that I pull all the tables from the different task lists. I was hoping for solution similar to what you can do with files in the same sharepoint folder, i.e. Combine Binaries
Is this possible with task lists?
Thanks
Matt
- v-lili6-msft
hi, Matt22365
After my research, I'm afraid it couldn't achieve in Power BI for now.
For your requirement, it needs you to pull all the tables from the different task lists.
Best Regards,
Lin
- Matt22365
Hi v-lili6-msft
Thank you for looking into this for me. That is a shame, I will, eventually, have about 20 sharepoint task lists which all need linking so will make the relationships complex.
I am struggling to link the 2 lists which I have active, Ive tried to make a relationship using the ID column but when visualised the 2 tables don't merge. Do you have any idea why this is happening?
Thanks for your help
Matt