Forum Discussion

mopetkewi's avatar
mopetkewi
Frequent Visitor
1 month ago
Solved

using sharepoint.contents

When trying to use sharepoint.contents to open a sharepoint folder in power query, we notice that for some users excel files are not recognized when we drill to the folder.  But if we change mcode to...
Need Help
  • ShivekMaharaj's avatar
    ShivekMaharaj
    1 month ago

    Hi mopetkewi​,

     

    Since SharePoint.Files is returning the workbooks correctly, I would avoid changing the downstream Excel logic for now and test the SharePoint.Contents source itself.

     

    One option that may be worth trying is the newer connector implementation:

    SharePoint.Contents("https://tenant.sharepoint.com/sites/site", [ApiVersion = 15, Implementation = "2.0"])

    Microsoft documents both ApiVersion and Implementation = "2.0" as supported options for SharePoint.Contents. The latter switches the call to the newer SharePoint connector implementation.

     

    I would compare this on one machine where the files appear and one where they do not. If the same site URL and credentials are being used but the result differs between students, I would also clear the SharePoint data source permissions in Power Query and reconnect with the same Organizational Account before testing again.

     

    Since SharePoint.Files already sees the files, this looks more like an enumeration/navigation issue with SharePoint.Contents than an issue with the Excel files themselves.

    AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 month ago

Hi mopetkewi,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Since the affected users can access the same SharePoint site and SharePoint.Files() returns the excel files successfully, this does not look like a general permissions issue. SharePoint.Files() and SharePoint.Contents() retrieve the share point content differently, so try using SharePoint.Contents() with ApiVersion = 15.

If the issue persists, consider using SharePoint.Files() instead, as it correctly returns the Excel files for the affected users.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 month ago

Hi mopetkewi​,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked?  or let us know if you need any further assistance.

Thanks and regards,
Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    29 days ago

    Hi mopetkewi​,

    We wanted to kindly follow up to check if the solution I have provided for the issue worked?  or let us know if you need any further assistance.

    Thanks and regards,
    Anjan Kumar Chippa