Creating Reports with Excel in Business Central: Live Data Using OData

May 23, 2025

Learn how to create real-time Excel reports connected to Microsoft Dynamics 365 Business Central using OData links! In this tutorial, we walk through the entire process—from setting up Web Services and using Power Query to building a dynamic "Sales by Customer by Item" report. If you're looking to streamline reporting without manually exporting data, this is the session for you. What You’ll Learn: How to use OData links to connect Excel to Business Central Step-by-step setup of Web Services pages How to use Power Query in Excel to filter and transform live data Creating dynamic reports with VLOOKUPs and calculated fields Tips for managing cache, credentials, and refreshing settings Whether you're in finance, sales, or support—this walkthrough helps you build reports that always reflect up-to-date data from your ERP. Want help implementing Business Central or training your team? Visit www.westerncomputer.com #BusinessCentral #ExcelReports #OData #PowerQuery #Dynamics365 #LiveData #ERPReporting #BusinessCentralTips #ExcelTips #FinancialReporting #MicrosoftDynamics Contact us for a personalized demo: https://bit.ly/32ChDNg. CALL: (805) 581-5020 VISIT: https://www.westerncomputer.com/ EMAIL: info@westerncomputer.com FOLLOW US: https://www.facebook.com/Western-Computer-236693736372775/ https://twitter.com/WesternComputer https://www.linkedin.com/company/western-computer

Previous Video
How Manufacturers Can Boost Efficiency & Profits with Smart Tech
How Manufacturers Can Boost Efficiency & Profits with Smart Tech

Are you struggling to get your product out the door efficiently while meeting customer demand? In this vide...

Next Video
Creating a Purchase Order in Business Central: Step-by-Step Tutorial
Creating a Purchase Order in Business Central: Step-by-Step Tutorial

In this video, we walk you through the complete process of creating a purchase order in Microsoft Dynamics ...

×

Would you like to speak to a Microsoft Dynamics expert? Contact us today:

First Name
Last Name
Product I'd like a demo of:
!
Thank you, we will be in touch shortly!
Error - something went wrong!