DIYAccountant

Datasource credentials for PowerBI Gateway

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 myContinue reading “Datasource credentials for PowerBI Gateway”

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”

Coffee table from a rotting piece of wood circa WW2 that a friend got from another friend.

This piece of wood was in pretty bad shape. I managed to stabilize it with PC Wood Hardener and epoxy. The rotting portion was very much a sponge. It sucked up about 3 bottles of wood hardener and lots of epoxy and varnish. I used a hand plane to plane the surface of the tableContinue reading “Coffee table from a rotting piece of wood circa WW2 that a friend got from another friend.”

Using PowerShell to access the tables in Business Central

I wanted a really simply way to access the tables in Business Central and to write the information of those tables into SQL database so that my team could access them directly from SQL. Since I am just an accountant, I always find it very difficult when I find snippets of code but nothing isContinue reading “Using PowerShell to access the tables in Business Central”

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.