The ability to filter data by user is critical whenever sensitive information is shared, whether internally to an organization or even more so externally. This is often known as “row… Read more »
The main appeal of Power BI’s new Datamart capability is arguably the fact it’s including a SQL Server instance that’s optimized for analytical purposes and is fully managed yet still… Read more »
Many Power BI developers come from an Excel background and have little to no SQL experience. Yet SQL databases are pervasive data sources and there’s not always a database administrador… Read more »
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 »