Adding .ODC file to Data Model (Power Pivot)

[kendy]

Hi,

I have generated ODC file (which contains real time data from Dynamics AX) and I would like to add this file to data model.

I can get data from .odc file as a table in Excel and if I update connection everything is working, however when I am trying to add this to data model, every time whenever I am refreshing connection to file it is updating sheet in Excel, but not in data model.

Do you have any idea how to add .odc file to my Data model?