Hello,I'm trying to connect to a SharePoint folder in Power query (Excel 365).I get an error message like this: Incorrect request (400)....etcFor information, the path is very long with many folders and subfoldersWhen I use a folder near to the Https root, it worksIs there a maximum length for the path?If not, how can I get round this problem?Thanks in advance Best regards

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.

You can use the OData connector to get both the most recent file and path and have it directly in Power Query vs running a macro if you want. The SP Folder connector is more for combining Excel file data; if you don't need the content of the file it's much easier to use the OData. I did a video on it a ways back if it helps: https://youtu.be/yeIQ9jKln_I?si=quk3f-RaCxoDiOF2

If it asks you to sign in repeatedly with no error, the fix for that is to go into the Power BI Desktop settings under Security and set it to use your default browser for authentication. I have had this happen to me too at various points... I don't know why it should matter, but it seems to resolve it.

SharePoint path not working | Microsoft Fabric Community

Forum Discussion

Related content

SharePoint Azure ACS Retiring — What’s the Supported Modern Auth Path for Fabric Pipelines?

Path Measure

Copy paths

Relative path with Web.Contents causing sharepoint authentication issues in Power BI

Path error