With the preview launch of Power BI datamarts in May 2022, Microsoft came with yet another data entity to contend with in the Power BI ecosystem. A year later, Microsoft… 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 »
Data-centric jobs are sitting by definition at the intersection of business and technology, and that affects who performs these jobs, their tools, and workflows. Traditionally data analysts tend to be… 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 »
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 »
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 »
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 »
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 »