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
- christinepayton
Most Valuable Professional
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
