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 »
I’ve been spending time lately trying to get a deployment pipeline to work for one of my clients and ran into a couple of non-intuitive limitations that I didn’t expect,… Read more »
On the surface it may look like Microsoft’s data gateway provides an even playing field between IaaS and PaaS approaches with regards to SQL hosting, i.e. you can run your… Read more »
Power BI’s DAX language is often described as “simple but not easy.” While visuals such as tables and matrices generate a lot of DAX behind the scenes, such as subtotals… Read more »
The main appeal of Power BI’s new Datamart capability is possibly the fact it’s including a SQL Server instance that’s optimized for analytical purposes and is fully managed yet still… 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 »
With the preview launch of Power BI datamarts in May 2022, there is yet another data entity to contend with in the Power BI ecosystem. I plan to update this… Read more »
This entry fills in the gaps of Microsoft’s official documentation as I had to go through a fair amount of trial and error to get things going. It assumes general… 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 »