Forum Discussion
Dataflow Gen 2 destination setup to SharePoint List
xxxxx.sharepoint.com/sites/xxxInsights/Lists
xxxxx.sharepoint.com/sites/xxxInsights
An exception occurred: Expression.Error: The column 'RootFolder' of the table wasn't found. (Session ID: acc75a8d-2acf-404b-904d-029759b9e0a6, Region: Australia).
Hi Anonymous,
Thank you for posting your query in Microsoft Fabric Community Forum.
The error you are seeing The column 'RootFolder' of the table was not found usually happens when trying to connect to a SharePoint List using an incorrect URL or connector. It looks like the connection string you are using might be targeting the SharePoint folder structure instead of the list itself.
To fix this, please make sure you are using the SharePoint Online List connector and not the SharePoint Folder or Web connector. Avoid adding /Lists/YourListName to the end that part is only for navigation in the browser, not for data connection purposes. Once you connect, you will see a list of available SharePoint Lists in the navigator. From there, you can pick the one you need and proceed with transforming or loading your data.
For step-by-step instructions and supported behaviour across tools like Power BI or Dataflow Gen2, here’s the official Microsoft documentation you might find helpful:
Power Query SharePoint Online list connector - Power Query | Microsoft Learn
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
4 Replies
Hi Anonymous,
Thank you for posting your query in Microsoft Fabric Community Forum.
The error you are seeing The column 'RootFolder' of the table was not found usually happens when trying to connect to a SharePoint List using an incorrect URL or connector. It looks like the connection string you are using might be targeting the SharePoint folder structure instead of the list itself.
To fix this, please make sure you are using the SharePoint Online List connector and not the SharePoint Folder or Web connector. Avoid adding /Lists/YourListName to the end that part is only for navigation in the browser, not for data connection purposes. Once you connect, you will see a list of available SharePoint Lists in the navigator. From there, you can pick the one you need and proceed with transforming or loading your data.
For step-by-step instructions and supported behaviour across tools like Power BI or Dataflow Gen2, here’s the official Microsoft documentation you might find helpful:
Power Query SharePoint Online list connector - Power Query | Microsoft Learn
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.Hi Anonymous,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
Hi Anonymous,
Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.Thank you.