See Microsoft 365 Copilot in action across Outlook, Teams, Excel + more.

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

How to Connect Power Pages & D365 Customer Engagement for a Seamless Self-Service Experience

Marisa Mini

|

December 4, 2025
Power Pages for Customer Service, Field Service, and Sales PortalsCreating a seamless, modern customer experience starts with reducing the back-and-forth. If your customers (or vendors, partners, applicants, members, etc.) still…

How to Tell if Your Distribution Business Has Outgrown Its Systems

Jennifer Ryan

|

December 1, 2025
As a former Controller inside a fast-moving distribution business, I learned this lesson the hard way: You don’t realize your system is breaking until growth exposes every weakness.It doesn’t happen…

Why Microsoft Killed Social Posting (And Why SMBs Should Care)

Jackie Gant

|

November 25, 2025
When Microsoft quietly pulled the plug on social posting in Dynamics 365 Customer Insights late last year, few in the small to mid-sized business (SMB) space raised an eyebrow. After…

Design Smarter, Present Better: How Microsoft 365 Copilot in PowerPoint Transforms Productivity

Joel Trinidad

|

November 20, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.The Presentation Problem We All Know Too Well The blinking cursor,…

How Microsoft 365 Copilot in Teams Helps You Work Smarter (and Recover Lost Time)

Joel Trinidad

|

November 18, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.The Communication Overload Holding Teams Back We’ve all felt it—the…

Free vs Paid: How Microsoft 365 Copilot Unlocks Real Productivity ROI

TJ Sedarski

|

November 13, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.Copilot Free Chat is a good place to start in…