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 […]
Financial Statements in Microsoft Power BI from Business Central
In Dynamics 365 Business Central, under Web Services, you’ll see the list of the APIs that are available. There are two different data sources – page type and query type – for the same type of information. You may want to try them both as some of the fields may be different. If you don’t […]
New Features in Business Central 2022 Wave 2 Release: Part 1
The new release of Microsoft Dynamics 365 Business Central is now generally available. Here are a few of my favorite features and enhancements that you may find useful: Multiple remit-to addresses for vendors Earlier, the vendor master only had one remit to address. Now vendors can have multiple remit -to addresses. So, if you’re paying […]
Microsoft Power BI Reporting in Microsoft Dynamics 365 Business Central
Previously, we have covered the Custom Report Layouts and Odata Reporting in Microsoft Dynamics 365 Business Central. One of the other powerful ways of reporting Dynamics 365 Business Central information is Microsoft Power BI. Power BI is a cost-effective web API tool with robust data analytics type functions. It’s very structured and does make good […]
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 […]