I have a data connection to a Sharepoint List (2013) in a development site; I now want to connect to the production version of this list and get an error..
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)
Im using the march 2019 version of Power BI Desktop
Im using the Sharepoint List connector
Following other posts, I have tried the connector with ApiVersion=15 (standard), ApiVersion=14 & removing the ApiVersion parameter altogether..
the list does have calculated columns, but so does the development site which works fine
I can import the list if I use the Web Connector, but I dont particularly want to do this..
lol this really is awful... if you change the API version, and if the locals of the server is different than the client, then you have a problem with the dates format! it is a vicious circle
Hi @Merchy2401 ,
Have you solved your problem?
If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Hi @Merchy2401 ,
I haven't reproduced your issue. Please delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works.
having found that response prior to me raising the call, I have tried to delete that dat source & Clear permissions, but the problem still remains.
as a work around I have reconnected to the sharepoint list using a Web Connector and it connects ok, but the native Sharepoint 2013 list connector is not working.
I have been having the same problem with one of my sharepoint sites. I think it may have something to do with a dash "-" in the name. My other sites don't give this error.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!