Forum Discussion

SevsBo's avatar
SevsBo
Icon for Continued Contributor rankContinued Contributor
5 months ago
Solved

Data from SharePoint list with Folders within the list?

We have a SharePoint list of open, rejected, and completed tickets:   I am trying to bring that into a Power BI report and I can get the data from the list quite easily using the SharePoint O...
  • v-menakakota's avatar
    v-menakakota
    4 months ago

    Hi SevsBo ,

    Thank you for the additional details.

    The examples you provided are helpful. The fact that Created Date is available through the legacy implementation but not visible in the Implementation="2.0" output, while the Reporter field is exposed differently between the two implementations, further demonstrates that the two connector implementations are returning different metadata and schemas for the same SharePoint list.

    As documented by Microsoft, Implementation="2.0" uses different APIs and is not backward compatible with the legacy implementation, so differences in returned metadata and behavior can occur between the two implementations.

    To help us investigate further, could you confirm whether the Reporter field is a Person column and whether the Created Date field is a standard SharePoint column or a custom column? If possible, please also share screenshots of the column settings from SharePoint.

    Best regards,
    Community Support Team