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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

JAngle 89 on at

Like (0)

Report

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

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

Helpful resources

Quick Links

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

#1

YUN ZHU 290 Super User 2025 Season 1

#2

Mansi Soni 196

#3

Gerardo Rentería Ga... 156 Most Valuable Professional

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans