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

Limited-time offer →

March 25, 2020

Configuring Data Source Settings within Jet Reports

Written by:

Picture of manager

manager

All Posts

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

Microsoft’s Built-In AI Explained: What You Get for $18/User

Clayton Jones

|

January 13, 2026
Licensing
Upcoming Lunch & Learn — See Copilot in Action in Microsoft 365 AppsJoin us for a 30-minute Lunch & Learn on January 22, where we’ll walk through how Microsoft 365…

From Frustration to Future-Ready: What Growing Distributors Need to Know About Their Systems

Jennifer Ryan

|

January 8, 2026
Article
I spent years on the other side of the table — inside distribution businesses, closing books at midnight, trying to reconcile inventory that never quite matched, and juggling spreadsheets that…

How Miron Violetglass Scaled 40% Without Adding Headcount

Jennifer Ryan

|

January 6, 2026
Article
Every distributor reaches a point where growth exposes the cracks: too many spreadsheets, too much manual work, and not enough visibility. Miron Violetglass hit that moment and what happened next…

Why Distribution Hand-Offs Break (and How Connected Operations Fix Them)

Jennifer Ryan

|

December 18, 2025
Article
Inside distribution companies, most problems don’t come from bad people or broken intentions. They come from gaps in the hand-offs between teams.As a Controller, I used to think our issues…

Unlocking Insights: Power BI Integration with Dynamics 365 Business Central

Joel Trinidad

|

December 16, 2025
Product features
As businesses increasingly rely on data to drive decisions, Microsoft continues to enhance the synergy between Dynamics 365 Business Central (BC) and Power BI. With the release of Business Central Version 26, users now…

The Spreadsheet Trap in Distribution: Why You Lose Control Without Realizing It

Jennifer Ryan

|

December 11, 2025
Article
Let me start with a confession: I love a good spreadsheet. They’re flexible. Fast. Familiar. Elegant.But here’s the problem no one talks about: Spreadsheets eventually become the system. And that’s…
Contact Us