Forum Discussion
Linking SharePoint Online List 2.0 Error
When I try linking my SharePoint Online list I am getting DataSource.Error: Web.Contents failed to get contents from (500): Internal Server Error. When I try to make it in 1.0 it works, but the Approval column which is a table does not load and gives the same error. I did convert the column on SharePoint from single to multiple people, which I feel like is causing this issue. All my other SharePoints work with similar fields. My list does have around 60,000 rows so maybe that's the issue?
Hello 23mulja
try this
Remove or exclude the Approval column during initial load.
Use API version 1.0, then handle Approval separately if needed.
Filter the list to load fewer rows (e.g., by date/status).
If performance remains an issue, consider moving data to Dataverse or SQL via Power Automate.
Let me know if you need the Power Query steps.
Power Query Code
let
// Replace with your SharePoint site URL and list name
Source = SharePoint.Tables("https://yourtenant.sharepoint.com/sites/yoursite", [ApiVersion = 2.0]),
// Find your list by name or filter it
YourList = Source{[Title="Your List Name"]}[Items],
// Remove the problematic column ("Approval")
RemoveApproval = Table.RemoveColumns(YourList, {"Approval"}),
// Optional: Keep only needed columns for better performance
CleanedData = Table.SelectColumns(RemoveApproval, {"Title", "Created", "Status", "AssignedTo"}) // adjust as per your list
in
CleanedData
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
4 Replies
- pankajnamekar25
Super User
Hello 23mulja
try this
Remove or exclude the Approval column during initial load.
Use API version 1.0, then handle Approval separately if needed.
Filter the list to load fewer rows (e.g., by date/status).
If performance remains an issue, consider moving data to Dataverse or SQL via Power Automate.
Let me know if you need the Power Query steps.
Power Query Code
let
// Replace with your SharePoint site URL and list name
Source = SharePoint.Tables("https://yourtenant.sharepoint.com/sites/yoursite", [ApiVersion = 2.0]),
// Find your list by name or filter it
YourList = Source{[Title="Your List Name"]}[Items],
// Remove the problematic column ("Approval")
RemoveApproval = Table.RemoveColumns(YourList, {"Approval"}),
// Optional: Keep only needed columns for better performance
CleanedData = Table.SelectColumns(RemoveApproval, {"Title", "Created", "Status", "AssignedTo"}) // adjust as per your list
in
CleanedData
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
v-echaithraCommunity Support
Hi 23mulja ,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.- v-echaithra
Hi 23mulja ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Chaithra. - v-echaithra
Hi 23mulja ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.