Getting data from on-prem sharepoint into Power BI Desktop

[brett_walton]

Hello, 

Having an issue connecting to some of my sharepoint list that are on prem. Some work , some do not, for the ones that do NOT I am getting this message ? - has anyone solved this before ? 

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)"

thanks brett