SharePoint path not working

Hi Mederic 

When you connect to Sharepoint folder online, you need to input the site url to the connection, you can refer to the following link.

https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder#connect-to-a-sharepoint-folder-from-power-query-online

sharepoint.stackexchange.com

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

The PBI folder connector requires the site URL, not the folder URL. You can then filter on the path in Power Query as one of the columns. SharePoint itself has limits on maximum path length, but if you're able to edit the file in SharePoint then it's probably okay. 

After a bit of searching, I quickly came across this link. It is indeed a problem of length
Is there a solution without having to move the folder ?

File Path too long - Excel, Office 2019, Win 10, SharePoint - Microsoft Community

Best regards

Hello Anonymous , christinepayton ,

Thank you for your answers,
I'm trying to use a Folder URL starting with https://, by "SharePoint Folder" connector in Office 365 and not in Power BI.
When I use the full path, I get an error message
When I use part of the path for example: "https://kkkk.com/:f:/r/site/document"
This works but returns several tens of thousands of results with all the files and I stop the process manually after a few minutes.

I finally used the URL directly with the Excel file: "https://kkkk.com/:f:/r/site/document/....../...../....../ExcelFile.xlsm".
This path is very long but works.

I don't have administrator rights to try to understand or modify the SharePoint path parameters.

The original idea was to be able to select the most recent file in a folder.

Finally, using a VBA macro, I'm going to manually select the path to the Excel file in a cell and then send it to Power Query.

Thanks

Best regards

Hello christinepayton ,

Thank you for another interesting suggestion.
I've just tested it with the Odata connector but unfortunately I didn't get any results.
I'm going to try it tomorrow from our company connection because at home I have to get special approval to access SharePoint (connection security via smartphone).

I will test this tomorrow from my office

For information, yesterday I said that the full URL with the Excel file works. I'll just point out that it's with a Web connector.
Have a good evening

Best regards

Hello christinepayton ,

Sorry for the late return,
I tested today at my office with the "ODATA" connector but unfortunately I can't connect. It keeps asking me to sign in to an account.

Thanks anyway for your help

Best regards