Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Item Ledger Entry in Power BI

(0) ShareShare
ReportReport
Posted on by 3,482

Hi:

In Business Central's Table Information window, I see the "Created At" field in the Item Ledger Entry table.

When I pull this same table into Power BI, I do not see this field.

Why is that, and how can I see this field in Power BI?

Thanks!

John

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Item Ledger Entry in Power BI

    Hi, just adding to others' reply.

    What Power BI can access, whether it's APIs or Web Services, are Pages (some of them are Query) and not tables, so you need to add to the page first to be able to do that.
    As mentioned by several experts above, this requires customization.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Item Ledger Entry in Power BI

    Hi John 

    90% of time I use Personalization and add the field that I want into the page I want. The rest of 105 I use Designer in Sandbox to add then download the app and upload in production (of course this is on your own risk).  Or if you have developer in house you can do this without Designer 

    In this case I think you need to use designer (Sandbox -> Settings -> Design ) 

    Then search for Create Data Set enter the name (without space) then select Page and then 83 and after that select fields you want then publish and consume this new web service. Not recommended since slow down the BC at refresh but if you refresh at night it works.

    Or get the Simple Object Designer which can handle lots of scenario 

  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: Item Ledger Entry in Power BI

    Hi MahGah:

    How do you do the second part?  :)

    John

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Item Ledger Entry in Power BI

    For that you need a developer to do that.

    Or you can try Simple Object Designer to publish API

    appsource.microsoft.com/.../PUBID.hougaard-4699382|AID.designer|PAPPID.4c032704-5c36-4480-b710-29e8565568bc

    I personally always used the second method since the first one was costly. But I am in unique position that I can refresh data between 6 pm to 5 am when nobody is in BC

  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: Item Ledger Entry in Power BI

    @MahGah:

    How do you go about using the first suggestion that you made?

    "1) Create a custom query that include that field. This is the recommended method."

    John

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Item Ledger Entry in Power BI

    hello

    these are the fields that the standard odata, the quey 265, shows you

    pastedimage1674491359532v1.png

    so you need a customization

    DAniele

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Item Ledger Entry in Power BI

    Hi John

    If you go to Web Services in BC then search for Item Ledger you can see Query has been published for it. Which means that query does not include Created By field.

    You have two way to go:

    1) Create a custom query that include that field. This is the recommended method.

    2) Add created by to page 38 (Item Ledger Entry) first. Then search for Create Data Set enter the name (without space) then select Page and then 83 and after that select fields you want then publish and consume this new web service. Not recommended since slow down the BC at refresh but if you refresh at night it works.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans