My post on which languages to learn as a Power BI developer resonated with many people so I thought I’d take a step back and write about how to navigate… Read more »
Pre-computing aggregates from granular data to improve live performance for end users by using computing resources at scheduled times is a well-established software pattern. In this entry we’ll look at… Read more »
This entry is a follow up to How to Find & Open Any File In a Jiffy with Launchy + Everything + Dopus, applied specifically to searching by title through… Read more »
Back around 2015, Microsoft introduced the current Power BI platform to replace its “Power BI for Office 365” SharePoint/Excel-based offering that most people have long forgotten, with a focus of… Read more »
Plex Media Server can be a pain in the neck to get fully working with a direct connection between your clients, whether on your local network or remote, and your… Read more »
No More Copying/Pasting Passwords in Power BI Desktop Unlike Office Microsoft 365 desktop applications, Power BI Desktop doesn’t keep track of more than one account at a time, which is… Read more »
In a previous entry I explained at length the various ways to secure data in business intelligence products. In this follow-up I want to elaborate on which method(s) to use… Read more »
While the initial consumer-grade NASes sold during the late 2000s/early 2010s had fairly weak CPUs and little memory, newer models priced in the $200-$500 range from about 2019 forward are… Read more »
This week it just happened that two of my consulting clients needed a date dimension table so I started revising my base Power Query template to make sure it was… Read more »
Recently I wrote about things you can’t do on the Power platform when querying an on-premises SQL database. Specifically, I wanted to recreate views in a database that gets wiped… Read more »