• Michael Intravartolo

Building Custom Reports in Business Central

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)















Add Filters:


Publish:




Web Services Page:



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



Power BI Desktop








Add Another Table to Dataset




Save and Publish Report










Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000

Email: info@solsyst.com

Support: 224-345-2020

Support Email: support@solsyst.com

  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
Find Quickly
Join our Mailing List
2020%20New%20Solution%20Systems%20Logo_e

© 2020 Solution Systems, Inc.

Plain Email Signature Transparent.png