Category Archives: Business Central

Power Automate and Business Central

Power Automate has Business Central connectors, however, they are very limited. What Power Automate does not have are connectors to Business Central for the Web Services. You can locate these web services in Business Central under Web Services. So how can you get access to the Web Services in Power Automate? Not that easy. ButContinue reading “Power Automate and Business Central”

Using Power Automate Service to Access Business Central Tables

If you are like me and do a lot of importing and sorting and just want data at your fingertips without having to go through Business Central, you like to have data either in SQL or in Excel. Why? Because you can do xlookups or other necessary evils when creating import tables with configuration packagesContinue reading “Using Power Automate Service to Access Business Central Tables”

Yet another Master Calendar Script for PowerBI

The Master Calendar is super important in PowerBI, especially if you want to run reports using relative dates or a series in time. Essentially all tables, should be linked to your master calendar via the date field. This is what PowerBI looks like when the dates are all joined. You should use the date fieldContinue reading “Yet another Master Calendar Script for PowerBI”

Foreign Exchange Tables / API in Business Central

We wanted to see all of the foreign exchange rates in Power BI from Business Central for various reasons: 1) To make sure the exchange rates were being updated daily and, 2) to run reports on the exchange rates Business Central stores the FX rates in table To create the API, go to WEB SERVICESContinue reading “Foreign Exchange Tables / API in Business Central”