{DataSource.Error} SharePoint: Request Failed: The Remote Server returned an error: (500) Internal

[bemp87]

When running Power Query to refresh the data, I am receiving the following error:

(DataSource.Error) SharePoint: Request Failed: The Remote Server returned an error: (500) Internal Server Error. (An error occurred while processing the request.)

Details:
    DataSourceKind=SharePoint

DataSourcePath=https://mysites.bemp87.com/personsal/abc123_login_bemp87_com/_vti_bin/ListData.Svc/SolutionGallery

I have not been able to resolve why i am receiving this error message which is preventing users from being able to 'Refresh' the data. Any assistance that can be provided will be greatly appreciated. 

[v-yuezhe-msft]

Hi @bemp87,

Regarding to Power Query issues, please post the question in the Power Query forum to get dedicated support.

And in your scenario, you can use Fiddler to capture a network trace, then send a Frown through the Power Query ribbon and attach the full trace.

Thanks,
Lydia Zhang