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)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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