Forum Discussion
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...
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
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