Uncategorized

  • 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’) there is no easy way to make all column widths equal in the format pane of a matrix visual. However there is a hack to set the width of your all columns in a matrix so that they are all equal and pixel perfect with DAX! How do you do this I hear you ask? Firstly create a…

    » Read more
  • 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 about the cube’s partitions. To use the tabular cube processing report, you need to insert the following information: Server Database (Cube Name) Once entered and assuming the connection is fine you need to accept some native queries. These statements are select…

    » Read more
  • 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 hosted online due to the current global pandemic. We converted the office into our own small venue with almost every screen being used over the week to display sessions. With the help of plenty of social distancing, plenty of pizza and the odd bacon sandwich… it worked quite well! Here…

    » Read more
  • How to delay a Python loop

    In this blog post, I will run through 3 different ways to execute a delayed Python loop. In these examples, we will aim to run the loop once every minute.To show the delay, we will print out the current datetime using the datetime module. 1 – SleepThe sleep function from Python’s time module pauses the Python execution by the number of seconds inputted. The example below pauses the script for 60 seconds. The above script has a 60 second…

    » Read more
  • Sorting a Power BI table by multiple columns

    A common request that is raised by clients is how to sort a table in Power BI by multiple columns, in the same way you can in Excel.For a while, there was no way (at least no easy way) to do this until the Power BI March 2020 update. I learnt this tip from the following YouTube video:https://www.youtube.com/watch?v=ik0K1H9j2UcFull credit to Dhruvin Shah, check his video out. Below I have a Power BI table displaying fruit sales, currently…

    » Read more
  • Capturing Insert and Update Counts from Merge

    This post shows hows how you can capture and store the number of records inserted, updated or deleted from a T-SQL Merge statement. This is in response to a question on an earlier post about using Merge to load SCDs in a Data Warehouse. You can achieve this by using the OUTPUT clause of a merge statement, including the $Action column that OUTPUT returns. The basic syntax is: INSERT INTO XXXX SELECT [Action] FROM ( MERGE XXXX AS Target USING XXXX…

    » Read more
  • Power BI Sentinel

    We all know and love Power BI, because of it’s power and ease of use, there’s a good reason why it’s number 1 in the Gartner Quadrant. But how to we avoid ‘Power BI Hell’, the new version of our old nemesis ‘Excel Hell’? How do we keep track of which data sources are being used by which datasets and reports? How to we perform an impact assessment of updating/changing a dataset? What happens if someone…

    » Read more
  • Sky Anytime – Killing Kontiki

    I think it’s about time for a good old rant. Nothing to do with Business Intelligence, but… Anyone out there who uses Sky Anytime (and I believe the BBC iPlayer) will have probably noticed that they use a nasty peer-to-peer file sharing application called Kontiki, which they install automatically without giving you any control over. My problem is that I have a good 8Mb download speed but my upload is still a rather paltry 256K (I…

    » Read more
  • The Frog-Blog is open for business!

    Well, what can I say – the very first Frog-Blog post. Keep checking back often for new and (hopefully) useful info… Alex

    » Read more