I'm cheap, so I try to do it myself.
If you are using PowerBI Service and the PowerBI Data Gateway but are having troubles authenticating to your local machine (i.e. you have an excel or csv file that you want refreshed) this may be the post for you. I use Office365 and have an @yourcompany.onmicrosoft.com account. That’s also the username to login to my…
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…
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…
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.
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.
Get new content delivered directly to your inbox.
DIY Accountant