PowerBI – DIY Accountant

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”

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”