Forum Discussion
Internal Server Error while importing SharePoint Online List
Hi everyone!
I was having the exact same issue with Sharepoint server 2013, and connecting using the Sharepoint list connector (Sharepoint.Tables, ApiVersion 14 in Power Query editor).
My table was working fine with the version 15 of the Api but would not work for the Version 14, which I need so dates stay the same as in Sharepoint.
My solution (it may not be everyone's case but I hope this helps someone else too) was to delete a Calculated column, which in this case gave as result html and icons which where veing queried from a library in the site.
Again, this may not be everyone's problem but it definetely is one of the possible causes, so it is worth checking 😉
Somewhat belated, but here is my workaround. In my case I needed to load the files from a SP Folder and be able to use the create/update dates in local (AUS) format. Using ApiVersion 15 resulted in parse errors on the date columns because they are not loaded with local format, so any day number > 12 is invalid. Using ApiVersion 14 loads the dates in the correct local format but causes internal Server Error 500. What I noticed was the error appeared as a row after the last row of filenames in the table. But unfortunately you cannot remove this row with a Table.RemoveRowsWithErrors statement (I guess because it is not really a row in the table). It occurred to me that I might be able to load the TopN rows with ApiVersion 14, where N is simply the number of rows that I determine using a Table.RowCount statement that uses ApiVersion 15. A tad convoluted, but bippity boppity boo, all my rows were loaded without an error, albeit without last access date:
let
#"SP Folder" = "
Source = Table.FirstN(SharePoint.Files(#"SP Folder", [ApiVersion = 14]), Table.RowCount(SharePoint.Files(#"SP Folder", [ApiVersion = 15])))
in
Source