Connecting to a D365 entity in PowerBI

[Anonymous]

Hello -

I am trying to create a report using my O-Data D365 online source. The two tables I need are: InventoryAdjustmentJournalHeaders and InventoryAdjustmentJournalLines. PowerBI allows me to import the headers but the lines entity is not given as an option when going through the navigator to load data. I am not sure as to why this is the case. I am able to load the InventoryMovementJournalHeaders and InventoryMovementJournalLines and everything. 

I checked in Visual Studio and this entity is not public. Is this the only reason as to why it's not showing in the Navigator?

I'm on a time crunch so any information is helpful! 

Thanks!!

[v-yiruan-msft]

Hi @Anonymous ,

If I understand correctly, table InventoryAdjustmentJournalLines is missing in Navigator list when connect to D365 Online,right?

Whether you can find both of these two tables when sign in Dynamics 365 (online) instance? And the account credential which type in connecting to Dynamics 365 (online) in Power BI Desktop is same with the one which sign in Dynamics 365 (online) instance? Could you please explain the steps which you done?

In addition, please check if the below documentation can help you.

Connect to Dynamics 365 (online)

How to Connect to Dynamics 365 Data from PowerBI Desktop

Manage data source credentials in Power BI Desktop

Best Regards

Rena

[Anonymous]

Hi @v-yiruan-msft ,

Correct, I am connecting the D365 online. The credentials I use in PowerBI Desktop are the same that I use to log into the system. This is a live PROD environment. I have system admin access with these credentials.

When clicking into my data source, the Navigator appears. I navigate to the InventoryAdjustmentJournalHeaders and look for InventoryAdjustmentJournalLines and it is not present. Only the headers. I have no trouble loading other data tables.

As I mentioned in my original post, InventoryAdjustmentJournalLines is not a public entity in AOS but InventoryAdjustmentJournalHeaders is. Could that be the reason it is not appearing in my navigator?

Thanks again!