Microsoft Copilot $21 now $18/user/month + 1 month free

March 25, 2020

Configuring Data Source Settings within Jet Reports

Please follow the steps below to set up a new data source within Excel Jet Reports in Business Central. Setting up the data source will allow the user to use their company’s information within the reports.

Open Excel.

Click the Jet Tab.

Click the Data Source Settings icon.

Click the “+” icon to create a new source.

A new window will prompt you to create a name for the source and identify the Database type.

The sign-in screen will appear where you will sign in using your credentials for the environment selected.

Once signed in, you will get the following window. Click Ok, and everything should be all set with creating your data source which will now allow you to begin using your data within Jet Reports.

Reach out to us for any other Microsoft Dynamics 365 inquires – support@BondConsultingServices.com

Share On: 

Other articles

Why Waiting for Perfect Data Means Never Starting with AI

Zoltan Orban

|

February 10, 2026
This post is part of our Microsoft Copilot, Explained series, which starts with everyday productivity tools like email and meetings before expanding into broader workflows and AI agents."Our data isn't…

Just Get Started: How Teams Are Actually Beginning with Microsoft Copilot

Clayton Jones

|

February 5, 2026
Getting started with Microsoft Copilot doesn't require perfect data, months of planning, or enterprise-scale resources. Small and medium-sized businesses running Microsoft 365 and Dynamics 365 Business Central are finding that…

Why Copilot in Outlook Beats Standalone AI Email Tools

Joel Trinidad

|

February 4, 2026
This post is part of our Microsoft Copilot, Explained series, which starts with everyday productivity tools like email and meetings before expanding into broader workflows and AI agents.Tools like ChatGPT…

Microsoft Copilot vs Copilot Chat vs Full Copilot

Joel Trinidad

|

February 3, 2026
This post is part of a series, Microsoft Copilot, Explained, which begins with productivity tools and building toward business workflows and AI agents. If you’ve been hearing more about Microsoft Copilot…

Microsoft Copilot for Operations vs Executives: Same Tool, Different Value

Zoltan Orban

|

January 29, 2026
Most conversations about AI in business stay at a high level: “It will transform how we work.”That might be true, but as someone who spends most days in the details—fixing…

Dynamics 365 Real-Time Journeys Explained: The “For Dummies” Version

Jackie Gant

|

January 26, 2026
Remember those bright yellow For Dummies books from the 2000s? This post is a throwback in that spirit: plain language, no fluff. If you’ve been hearing about Microsoft’s “Real-Time Journeys”…