In Microsoft Dynamics 365 Business Central, the financial reports are available in a nice almost printable format especially if you know how to export it and refresh it with your own formatting. But sometimes, you need the raw data quickly in a Pivot Table format or a Power BI refreshable report for data analysis. To […]
New Feature in Business Central 2023 Wave 1 Release: Analyze View
Of all the new features in the latest release of Microsoft Dynamics 365 Business Central, Analyze View is probably my favorite one. With this feature, you can analyze data from list pages within the application itself, essentially turning it into a pivot table. To do something like this in the past, you would have to […]
Reporting With OData Queries in Business Central – Part 2
In this video, I’ll demonstrate how to use some of the advanced functionality in the power query editor to query things from Microsoft Dynamics 365 Business Central/Tensoft SemiOps/ DemandOps or any OData source. Firstly, I’ll cover how to combine queries together in two different ways – Merge and Append. Merge is joining two related datasets […]
Reporting With OData Queries in Business Central – Part 1
OData queries are URLs that can expose any table or any piece of data that’s in Microsoft Dynamics 365 Business Central via the Web Services Page. It comes with a bunch of already delivered web services, but you can add new sources as needed by clicking on ‘New’ and then referencing either the Page that […]
Microsoft Dynamics 365 Business Central April 2022 Release: What’s New?
April is here and so is the new release of Microsoft Dynamics 365 Business Central. Most of the new features and enhancements have been in public preview since March 1, 2022. Here are some that we found interesting: New capabilities for financial reporting with account schedules We are excited to see some of the new […]