Forum Discussion
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:
- I clicked Get Data.
- I clicked More....
- I selected SharePoint Folder.
- I pasted the SharePoint site URL (https://xy.sharepoint.com/sites/Testsite).
- 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.
Hi Brianhungary,
Thanks for the additional testing. Since API 14/15, Auto, SharePoint.Contents, and the specific library URL have already been tested, one remaining documented option is to test SharePoint.Contents with Implementation = "2.0". Microsoft documents this implementation for the SharePoint connector. If the same error or an empty result occurs, the current Microsoft documentation does not provide a documented fix for the ExtendedSharePointPermissionOfflineDaysForLibrary error
Power Query SharePoint Folder Connector - Power Query | Microsoft Learn
SharePoint.Contents - PowerQuery M | Microsoft Learn
SharePoint.Files - PowerQuery M | Microsoft Learn
Thank you.
9 Replies
- pankajnamekar25
Super User
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 - YouTubeHello, Thank you for your answer, I tested the suggestions:
1. ApiVersion:
Auto mode - does not load anything, just open an empty table.
ApiVersion 15: - same error when I use the wizard
ApiVersion 14: does not load anything, just open an empty table again.
2. I navigated to the Sharepoint document settings site, but I could not find the the extend protection function. Could you please help me to describe it ?
3. Fallback. I tried the Sharepoint.Contents(url) function, and it loads an empty table again without error message.
Thank you.
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:
- 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.
- Check if the library has any offline sync / offline availability settings enabled (the property name points that way) — try disabling temporarily as a test.
- 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.
Hello thank you for your ideas,
1. The Sharepoint implementation toggle is missing from this option pane. Is it a problem?
2. the sharepoint libary is set to enabled for offline sync. I can not test it because the users, have no internet connection most of the time. What is the possible reason behind your idea, maybe I could simulate it.
3. The specific connection url drop "BadRequest 400 error".
thank you so much.
- rajendraongole1
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.
Hello thank you for recomendations,
I tested the ApiVersions with these results:
1. without ApiVersion detailed - power query load an empty table with headers and without content
2. ApiVersion 14 - same situation, but the result is not a table, it looks like the header only.
3. ApiVersion 15 - "The property 'ExtendedSharePointPermissionOfflineDaysForLibrary' does not exist on type 'SP.List'. Make sure to only use property names that are defined by the type."
thank you so much for ideas
v-saisrao-msftCommunity Support
Hi Brianhungary,
Thanks for the additional testing. Since API 14/15, Auto, SharePoint.Contents, and the specific library URL have already been tested, one remaining documented option is to test SharePoint.Contents with Implementation = "2.0". Microsoft documents this implementation for the SharePoint connector. If the same error or an empty result occurs, the current Microsoft documentation does not provide a documented fix for the ExtendedSharePointPermissionOfflineDaysForLibrary error
Power Query SharePoint Folder Connector - Power Query | Microsoft Learn
SharePoint.Contents - PowerQuery M | Microsoft Learn
SharePoint.Files - PowerQuery M | Microsoft Learn
Thank you.
- v-saisrao-msft
HI Brianhungary,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
- v-saisrao-msft
Hi Brianhungary,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
