Forum Discussion

Brianhungary's avatar
Brianhungary
New Member
8 hours ago

Power BI - Sharepoint folder

I would like to load a SharePoint folder that contains images into Power BI Desktop. These are the steps I followed:

  1. I clicked Get Data.
  2. I clicked More....
  3. I selected SharePoint Folder.
  4. I pasted the SharePoint site URL (https://xy.sharepoint.com/sites/Testsite).
  5. After clicking OK, I received the following error message:

"The property 'ExtendedSharePointPermissionOfflineDaysForLibrary' does not exist on type 'SP.List'. Make sure to only use property names that are defined by the type."

I have the required permissions. In fact, I am the owner of the SharePoint site. I do not understand why this is not working.

So far, I have:

  • Installed the latest updates.
  • Restarted my computer.
  • Created a completely new PBIX file.
  • Signed out of and back into my m365 account.
  • Cleared the Power BI cache.

However, I still cannot get it to work and I have no idea what else I could try.

Does anyone have any suggestions or ideas about what might be causing this issue?

Thank you in advance for your help.

power bi

3 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Icon for Super User rankSuper User
    8 hours ago

    Hello Brianhungary​ 

    Try this

    Set ApiVersion = 15 (or 14) explicitly on the SharePoint.Files(...) step in the M code.

    Uncheck "Extend protection on unencrypted files..." in the library's settings, then reconnect.

    Fallback: use SharePoint.Contents(url) instead of the Folder connector.

    If my response helped you, please consider clicking
    Accept as Solution and giving it a Like – it helps others in the community too.

    Thanks,

    Connect with me on:
    LinkedIn |
    Data With Pankaj - YouTube

     

  • m4ni2020's avatar
    m4ni2020
    New Member
    6 hours ago

    Odd one — doesn't look like a real permissions issue, more a schema mismatch between the connector and what your library's REST API is returning.

    A couple of things to try:

    1. File > Options and settings > Options > Global > Data Load — toggle "SharePoint implementation" (1 ↔ 2) and reconnect. Fixes a surprising number of weird schema errors like this.
    2. Check if the library has any offline sync / offline availability settings enabled (the property name points that way) — try disabling temporarily as a test.
    3. Try connecting to the specific document library URL (e.g. .../sites/Testsite/Shared Documents) instead of just the site root.

    If none of that shifts it, it's probably worth raising with Microsoft support as a connector/tenant schema mismatch rather than something fixable on your end.

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    4 hours ago

    Hi Brianhungary​ - For SharePoint.Files(), I’ll explicitly specify API version 15, for example:

    let Source = SharePoint.Files( "https://xy.sharepoint.com/sites/Testsite", [ApiVersion = 15] ) in Source

    Microsoft documents API versions 14, 15, and "Auto" for SharePoint.Files(), with version 15 being a valid option.

    SharePoint.Files - PowerQuery M | Microsoft Learn                                                    SharePoint.Contents - PowerQuery M | Microsoft Learn

    alternative:

    let Source = SharePoint.Contents( "https://xy.sharepoint.com/sites/Testsite", [ApiVersion = 15] ) in Source

    SharePoint.Contents() navigates the SharePoint hierarchy (libraries → folders → files), whereas SharePoint.Files() returns a flat table of files across the site and subfolders. Microsoft also documents the newer Implementation = "2.0" option for SharePoint.Contents().

    I hope this detail helps to sortout the issue.