Skip to content


Introducing the Query Builder for Dynamics 365 Business Central

The biggest problem we see with the cloud is that you do not have table-level access for reporting. We’ve fixed this issue for Dynamics 365 Business Central with the Query Builder, which is a new feature now available with the Popdock for Dynamics 365 Business Central app.

Table-level queries without code

With the Query Builder, everyone can build their own optimized queries right from BC tables. The easy interface lets you select tables and fields, and then join them to other BC tables to build your own query.

These queries can be simple or complex. You have access to:
  • Tables and columns across all your Dynamics 365 Business Central data – even ISV tables, your extensions, and all your dimensions.
  • Search and select any fields you want to use – even the ones that aren’t exposed on your Dynamics 365 Business Central pages.
  • Create joins and see both left/right outers.
  • Use restrictions and summarize.
  • Build really rich queries that are optimized for performance.
The best part about this is you will never have to write AL code for your queries again.

Publishing your Dynamics 365 Business Central API

Then, with a click of a button you can publish the query as a Dynamics 365 Business Central endpoint to use where you’d like – in PowerBI, for your integrations, or for any other way you’d like to call that data.

Essentially, this means users have the power to create and modify optimized API queries for Dynamics 365 Business Central quickly without needing to learn or write any AL code. We think this will be pretty powerful for our partners to deliver requirements faster without custom development and for our customers to have all the reporting power they want as they move to the cloud.

Check out a quick introduction of the Query Build in action here:

To access the Query Builder for Dynamics 365 Business Central:

1. Get started with a Popdock Business Level Plan.
2. Access and download Popdock from Dynamics 365 Business Central.

If you have any questions about getting started, reach out to our team via chat or at We’re happy to help you get started with the Query Builder for Dynamics 365 Business Central.

Leave a Comment


Accessing Your Historical Dynamics NAV Data in D365 Business Central - Part 1: Getting Started
eOne Welcomes Incremental Group as a New eOne iPaaS Integration Partner
Employee Spotlight: Floyd Jones, Front End Developer
NEW WEBINAR: Popdock Onboarding - Fall in Love with Your Data
Employee Spotlight: Calum McGrath, Implementation Consultant


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.