Forum Discussion

Mederic's avatar
Mederic
Icon for Post Patron rankPost Patron
2 years ago

SharePoint path not working

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)....etc For information, the path is very long with many ...
Need Help
christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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.