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”
Category Archives: 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”
Printing lots of PDFs with Powershell
We get invoices as attachments saved to a folder from our email. Here’s a little script I wrote to print out all of the PDFs from that folder.
DIY Accountant 