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 […]
How to use Excel to Format Reports in Microsoft Dynamics 365 Business Central
The formatting in Account Schedules is fairly basic in Microsoft Dynamics 365 Business Central. However, you can take it to the next level by exporting the output into excel and building a template that references the output and then formats it into something nicer. For an in-depth demo, view the video or read the summarized […]