OData location to link to live data in form name LedgerJournalTable for Power BI

(0) Share

Report

Posted on by ReganMitchell

105

Hey guys,
I would like to connect Power BI via OData to pick up data in this table https://####.operations.dynamics.com/?cmp=####&mi=LedgerJournalTable6, particularly fields /Posted on/ (control name /LedgerJournalTable_PostedDate/) and /Modified by/ (control name /LedgerJournalTable_ModifiedBy). Can you please advise the location so I can do this?
Cheers,
Regan

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

OData location to link to live data in form name LedgerJournalTable for Power BI

Hi, You can use this data entity for LedgerJournalTable6 but you need to expose PostedDateTime and ModifiedBy fields in data entity from visual studio.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

OData location to link to live data in form name LedgerJournalTable for Power BI

You can ask Developer to create Data Entity extension and add those fields in that data entity.

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (0)

Report

OData location to link to live data in form name LedgerJournalTable for Power BI

Hi Regan,

You need to extend the data entity and add the required fields from DataSource to data entity fields.

You can refer to below blog.

https://d365ffo.com/2021/05/06/d365ffo-ax-add-new-field-to-a-data-entity/

Thanks,

Girish S.

Was this reply helpful? Yes No