Forum Discussion
Post PatronSharePoint path not working
Post PatronHello 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
Most Valuable ProfessionalYou 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