Hi. Our new ERP system are using Odata v4 for the odata feeds, and I am not any longer able to connect Power Pivot to these feeds. Do anyone know wheteher Power Pivot supports Odata v4 data or not?
Odata v4 & Power Pivot
@JonKval-9680
Is there any update?
If your issue was resolved, welcome post back and share us your solution.
The matter is not resolved. I have not found out how to load odatav4 feeds from Microsoft Dynamics BC365 into PowerPivot. (I know it can be done with PowerQuery)
From your description it seems you've been importing oData data into the Data Model straight from Power Pivot (if this isn't the case, please clarify):
TBH I have no idea which oData versions are supported by Power Pivot. However - AFAIK - the oData connector for Power Query/Get & Transform and Power BI supports oData v4
So, instead of connecting to your oData feeds from Power Pivot, proceed as follow (summary of steps) - from Excel:
- Go to the Data tab > Get Data > From Other Sources > From oData Feed
- Enter your url > OK
- Select your table(s)
- At the bottom of the Navigator window > Click on the arrow down next to Load > Load To... > Check options Only Create Connection + Add this data to the Data Model
Hi @JonKval-9680. Have you had time to check the above possible solution with your ERP? It would be appreciated to get your feedback as other users/partners could benefit from your experience. Thanks in advance
Hi. This was really not the issue. My issue wer that I can notsee how I can import a Odatav4 stream coming from the ERP system to PowerPivot. It doesnt look like PowerPivot support data with Odatav4 protocol.
@JonKval-9680
Please refer to Lz-3068's answer to have a check.
Besides, you may check whether this article "ODATA Reads" is helpful.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
OData Feed through Excel or Power Pivot vs. Power Query article is old. However, after checking my Microsoft 365 installation the following still appear to be true:
Power Pivot uses Microsoft.Data.DataFeedClient (%ProgramFiles%\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\DataModel)
Power Query uses Microsoft.Data.OData (%ProgramFiles%\Microsoft Office\root\Office16\ADDINS\Microsoft Power Query for Excel Integrated\bin)
Couldn't find info. re. the oData version(s) suppored by the former though
@JonKval-9680
As I do not have a test environment for further research, to better help you, I suggest you post a new thread on Microsoft Community forum.
Thanks for your understanding.
5 people are following this question.
