How to make your matrix column widths all equal to each other in Power BI using DAX.
Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right?
Unfortunately (as of April 21’) […] Continue Reading…
Azure Synapse Series: Hash Distribution and Shuffle
For this post I’m going to presume you’ve already taken a look at distributing your data using a hash column, and you’re not experiencing the performance you’re expecting. (If […] Continue Reading…
Power BI Drill Through using Multiple Data Points
A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, […] Continue Reading…
Azure Analysis Services Cube Backup
This blog is a quick guide on how to back up an Azure Analysis Services cube using PowerShell. The PowerShell is used in a runbook inside an Automation account […] Continue Reading…
ADF Switch Activity – A neat solution for nested IFs.
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored […] Continue Reading…
Tabular Cube Processing Report
I have created a Power BI report which provides detail on the state of processing in a Tabular Cube.The report uses the cube’s dynamic management views to provide information […] Continue Reading…
My Experience of SQLBits 2020
A few weeks ago, Purple Frog attended SQLBits 2020 (the largest data conference in Europe). This year the event had a change of pace as the whole conference was […] Continue Reading…
Speaking at Data Platform Summit
I’m delighted to have been selected to speak at the Data Platform Summit (DPS), a virtual conference from 2nd to 4th December 2020, with Data, Analytics and Machine Learning […] Continue Reading…
How to block the creation of a classic workspace in powerbi.com when a new MS Team is created!
There is now a new tenant setting for Power BI admins to prevent users from creating classic workspaces in Power BI! This includes from places like MS Teams! Hurrah!
If […] Continue Reading…
My experience in obtaining an MCSE
Background
I have recently completed my MCSE in Data Management and Analytics, and I wanted to share my experience of working towards and passing the exams that have led to […] Continue Reading…
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Reiss McSporran |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
