web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... A PowerBI Report listi...

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

Suggested Answer

A PowerBI Report listing Journal number, posting date, user who entered the journal and journal approver

(0) Share

Report

Report

Posted on by DBOOTH221177

10

Wondering if anyone can help? I am trying to create a report in PowerBI which shows the journal information, debits and credits etc, but also shows who the user who entered the journal was and the approver (ID and approval date).

I have tried via General_Ledger_Entries, G/L_Register and Posted_Approval_Entries tables and making the relevant field relationships, but the report doesnt appear to work in all cases.

Has anyone tried this via PowerBI? If so, any help and pointers will be greatly appreciated.

Thanks in advance!

DBOOTH221177

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

JAngle 157 on at

Like (0)

Report
Copy link

Link copied!

Perhaps a query api will help instead. Assemble the required data with this and then call it in Power BI. Any gaps can then be plugged with transformation in Power BI. Will make the processing time of the report better if the data formation is BC side instead.

This might help: docs.microsoft.com/.../devenv-walktrough-designing-reports-multiple-tables

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,029 Super User 2026 Season 1

#2

YUN ZHU 1,226 Super User 2026 Season 1

#3

AndrewThomas81 1,201

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans