Forum Discussion

Matt22365's avatar
Matt22365
Icon for Resolver III rankResolver III
7 years ago
Solved

How 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 lis...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
Matt22365
Icon for Resolver III rankResolver III
7 years ago

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 

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Matt22365 

    What is "when visualized the 2 tables don't merge" mean? Could you share some screenshots for it and what is your expected output. if you had created the relationship correctly. If possible, please share some simple sample data and expected.

     

    Best Regards,
    Lin

    • Matt22365's avatar
      Matt22365
      Icon for Resolver III rankResolver III
      7 years ago

      Hi

       

      So Ive imported 2 sharepoint task lists and created a relationship between the 2 tables. Ive tried a few options for the relationship, the screenshot shows one of the options Id - Id.

      Now these are linked I hoped that any visual I create would use data from both fields, however the data seems to be staying independent. The below screen shot shows a table which should merge all the request numbers from the ACF and DR tables (data should include TL-ACF-2019_XX and TL-DR-2019_XX), however, the merge isnt happening and I am only seeing data from one of the tables, depening on which table I take the values from

       

      I have also attempted to build a bridging table between the 2 data sets using the team name (calculated column to give each table an individual team name), screenshot below. This also did not give me a merged table

       

       

      Any help would be greatly appreciated

       

      Thanks

       

      Matt