data refresh errors while consuming odata feed url as a data source

shiningstar

New Member
Joined
Sep 26, 2014
Messages
7
I am using PowerPivot tool to load the data from a feed.But I am getting weird error like

Error in high-level relational engine.The following exception occured while the managed IDb Command interface was being used:The remote server returned an error:(500) Internal server error.. An error occured while the parition,whith the ID of 'TABLE_NAME_db99b079-bd0d-4150-b9ef-8ee6012e2e232b'.Name of 'TABLE_NAME' was being processed. The current operation was cancelled because another operation in the transaction failed. Example feed is like this XXXXXX:1028/Reporting/MDN.svc

How can I troubleshoot this?
 
Last edited:

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Hmmm. I would want to blame the oData feed. Do you own it? I would try calling it w/o powerpivot to see if it seems to be working ok?
 
Upvote 0

Forum statistics

Threads
1,215,352
Messages
6,124,451
Members
449,161
Latest member
NHOJ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top