Forum Discussion

DSTUART's avatar
DSTUART
Regular Visitor
8 years ago

Relations between Sharepoint List/Workflow Task/Workflow History

Hello folks,   Ok this has been driving me insane for a few days now. I have created a list in O365 that is connected to a Nintex Workflow.   Im trying to create a dashboard that displays all tas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

DSTUART,

How do you connect to your data source in Power BI Service? Do you want to create relationship between tables using UniqueID/DataID?

Regards,
Lydia

  • DSTUART's avatar
    DSTUART
    Regular Visitor
    8 years ago

    Hi Lydia,

     

    I have used both the Sharepoint Online and OData connectors. Once I have pulled in the table I have also expanded all the other tables to Identify a unique value that I can use to join them. But so far I have not had any luck.

     

    I would like to be able to link all three lists together so I can provide a single clean report.

     

    Dave

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      DSTUART,

      You can create relationships between tables in Power BI Desktop. One of the tables should contain unique IDs in order to establish relationship. If you have duplicate IDs in each table, you can create a bridge table containing all the possible IDs, then create realtionship using the table and other tables.

      Regards,
      Lydia