Los Angeles Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Audit Report for Business Central Data - Created at unavailable [Solved]

  • 1.  Audit Report for Business Central Data - Created at unavailable [Solved]

    Bronze Contributor
    Posted Feb 25, 2021 07:41 PM
    Edited by Tim Andaya Feb 26, 2021 12:12 PM
    Hi,
    Posting for an associate:

    Creating an auditor report and the auditor wants to know when records were created, they don't care so much about what the transaction date is.

    In Business Central, I can see the table data and it has a field System Created at which shows the record creation date.  I can filter within Business central on the date criteria.  When I link to the data source in Power BI; I can't see this date.  I think this might be a user security issue but, I wondered if anyone else might have an answer for me.

    Thanks in advance.

    ------------------------------
    Tim Andaya
    Strategic Systems Group
    Torrance CA
    310-539-4645 xt. 103
    ------------------------------


  • 2.  RE: Audit Report for Business Central Data - Created at unavailable [Solved]

    Bronze Contributor
    Posted Feb 26, 2021 12:11 PM
    Edited by Tim Andaya Feb 26, 2021 12:15 PM
    I did get a response from Steven Renders:

    The field SystemCreatedAt is indeed available on table level. In PowerBI you import web services. That means you need to add that field to the source queries/pages to be able to import them in PowerBI.

    When you add the field to the source page/query, you can see and import it in PBI:

    Shows how to enable a new field a Business Central Query


     

     I hope this helps someone in the future



    ------------------------------
    Tim Andaya
    Strategic Systems Group
    Torrance CA
    310-539-4645 xt. 103
    ------------------------------