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

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