Blog Content

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. But…

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 packages…

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 field…

Something went wrong. Please refresh the page and/or try again.

About Me

Hi. I’m Jeff. I have been CFO/VP Finance for over 15 years for various companies. Since my first position as accounting manager right out of Deloitte I have been using data and automating processes for every company I have worked for. The most interesting part of it is that I have done it all on my own.

Subscribe to My Blog

Get new content delivered directly to your inbox.