Power-Pivot:500 Internal Server Error

Question

I am importing the ssrs report from .automsvc extension and I am facing the below issue as .Can any one help me how can I solve this issue

Tablix1: The remote server returned an error: (500) Internal Server Error.

A 500 error should wind up in the SSRS logs; perhaps start by looking there and see if you can find anything useful? — kyzen, May 22 '14 at 16:31

score 0 · Answer 1 · answered May 13 '15 at 18:51

0

If you have any date columns delete them from the SSRS report and see if the PowerPivot connection works. You may need to play with formatting if you want to add the columns back. Trial and error.

answered May 13 '15 at 18:51

Timbo

1

score 0 · Answer 2 · answered Jul 20 '16 at 19:58

Yea, took me a bit to find, but the issue is simple and also stupid. Power Pivot has issues with importing "Calculated Fields" - But I think these are Sharepoint created and might still work with Infopath created Calculated fields, hope this helps someone. Once I removed the calculated fields I stopped getting this error immediately.

Power-Pivot:500 Internal Server Error

2 Answers2