MicrosoftHi Jose_Barreto
First off, I love the MGDC datasets - these are a great improvement for SharePoint reporting over having to scan/crawl everything!
Can you help me with creating a primary key for the permissions dataset? I have ADF pipelines that process delta datasets into SQL, handling the insert,update,delete operations. For other datasets (e.g. sites, files, groups) the primary key is obvious. However in the permissions one, I can't see any column that is unique in itself - presumably it needs to be a combination of columns.
I initially thought the "uniqueid" column was it, but I see that is the ID of the item (BTW, that column is not listed in the documentation on GitHub - https://github.com/microsoftgraph/dataconnect-solutions/blob/main/Datasets/data-connect-dataset-sharepointpermissions.md)
Any ideas?
Trev
