Is it possible to connect multiple SharePoint Online lists to the same entity in CDS? I would like to collect data from each list then report on it in Power BI. Or is there a better way to achieve this? Thanks!
Yes, this is possible. There is a Document Location entity (sharepointdocumentlocation) that is linked to a CDS record via the regardingobjectid field, and to the SharePoint list via the parentsiteorlocation field (which references a SharePoint Site (sharepointsite) and either the relativeurl or the absoluteurl field. It is possible to create multiple sharepointdocumentlocation records for one CDS record