New Year, Smarter Work: Get 1 Month Free Copilot | Now $21/User.

Claim 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

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…

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

Marisa Mini

|

December 4, 2025
Product features
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
Article
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
Updates and new features
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…
Contact Us