Dynamics 365 (for Operations) online ODATA connection to PowerBI

[Hawk-Star]

I have been trying to connect PowerBI to the ' CustTransOpen' table in Dynamics 365 for Operationsto with no joy inPowerBI Desktop.

I can connect to the 'Customers' table.

Looking at other forums, etc. the 'CustTransOpen' Table is not an ODATA table.

Is there a way making the 'CustTransOpen' table have an ODATA feed/table as this would be useful as will have other tables I will need to connect with againg having the same connection problem?

[Anonymous]

Hi Hawk,

you need to create a custom Data Entity with the 'CustTransOpen' Table and set it public to be able to access it via Odata.

https://community.dynamics.com/ax/b/dynamicsaxinsightbyanas/archive/2017/06/13/ax7-d365-operations-c...

Greetings, Christian