top of page

Building Custom Reports in Business Central

Updated: Aug 16, 2021

You either just purchased or upgraded to Microsoft Dynamics 365 Business Central and you are wondering what's the best route to take to create reports? Should I have my Microsoft Partner create custom reports for me? Should we purchase an extension such as Jet Reports? Can we just use Microsoft Power BI? The answer is yes, you can use all three of these options. However, before going down the route of having your Microsoft Partner customize a report for you or purchasing the Jet Reports extension we'd highly recommend exploring Power BI coupled with Business Central.


Business Central's Assisted Setup feature for Reporting is amazingly simple and easy to use to create reports. Watch the below video to see just how easy.




1) Assisted Setup: Set Up Reporting Data (create the dataset)

a. Page – single Table (no Extension required)

b. Query – multiple Tables (Extension required)



Microsoft Dynamics 365 Business Central Assisted Setup Page

 

Microsoft Dynamics 365 Business Central Reporting Data setup

 

Microsoft Dynamics 365 Business Central Reporting Data Setup

 


Microsoft Dynamics 365 Business Central Reporting Data Setup

 



Microsoft Dynamics 365 Business Central Reporting Data Setup

Add Filters:


Microsoft Dynamics 365 Business Central Filter Page

Publish:



Microsoft Dynamics 365 Business Central Reporting Data Setup

Web Services Page:


Microsoft Dynamics 365 Business Central's Web Services Page for reporting.

Connect to Data Source from Excel -> New -> PowerPivot


Microsoft Dynamics 365 Business Central Power Pivot for Excel

Power BI Desktop


Microsoft Power BI Get Business Central Data

 

Microsoft Power BI Business Central Data

 

Microsoft Power BI Visualization


Add Another Table to Dataset


Microsoft Power BI establishing relationships


Microsoft Power BI Dashboard Visualization


Save and Publish Report


Save and publish your Business Central report created in Power BI Desktop.


 

Publish Power BI Desktop data to Power BI cloud portal.


3 Comments


Addend Analytics
Addend Analytics
Jun 21, 2022

Really an informative blog on Building Custom Reports in Business Central. Thanks Michael Intravartolo for posting it. To know more about business central visit us at https://addendanalytics.com/

Like

Megan Cassidy
Megan Cassidy
Mar 31, 2021

oh! This saves LOADS of time! Thank you!

Like
Replying to

Thank you for the kind words and you are very welcome! If you are interested in more Power BI and/or Business Central discussions, tips, etc. you should check out our LinkedIn pages. Our Power BI page has over 48,000 subscribers and our Business Central page has over 9,000 subscribers and we're fortunate to have both of these pages help many people. Here are the links:


Power BI Page: https://www.linkedin.com/showcase/microsoft-power-bi-by-solution-systems


Business Central Page: https://www.linkedin.com/showcase/microsoft-dynamics-cloud-solutions


Thanks again and best of luck with Power BI and Business Central! 😀

Like
Follow Us!

Recent Articles

bottom of page