Call today 0845 643 6463

Blog

  • Variable Libraries In Microsoft Fabric, In Preview!

    June 13th, 2025 in Blog, Microsoft Fabric

    In Preview: Variable Libraries in Microsoft Fabric Microsoft Fabric’s variable libraries offer a powerful way to streamline your CI/CD processes, especially when you’re working in a shared workspace. In this post, we’ll explore the key benefits of this feature and how it can boost your team’s productivity. What Are Variable Libraries in Microsoft Fabric? Variable libraries in Microsoft Fabric let you store and manage variables in a…

    » Read more

  • AI Is Taking Jobs? — Task Elimination over Job Elimination

    June 2nd, 2025 in AI, Blog, Copilot

    When people talk about AI and jobs, the conversation usually swings between two extremes: utopian visions of AI-enhanced productivity or dystopian fears of mass unemployment. But the reality is more nuanced, and more immediate. Jobs aren’t being replaced, merely redefined by the elimination of low level tasks. The Shift: From Roles to Tasks Recent studies show that AI is not eliminating entire professions overnight. Instead,…

    » Read more

  • BLANK() Function Not Working As Expected

    May 1st, 2025 in Blog, DAX, Power BI

    Trying to handle blank values in Power BI… I needed a measure that would fill blank gaps across days where a value wasn’t present – I thought the BLANK() function would help me achieve this. My goal for the results of the measure is shown below: The logic is quite simple, if the value on that day is not blank, take that value. If it is blank then take the previous non-blank value. The first piece of logic is to get the date where…

    » Read more

  • Is AI cheating?

    April 28th, 2025 in Blog, Business, careers

    I was recently a Judge at a  ‘Dragons Den’ event at a local school. They had been split into teams and tasked with creating an innovative app idea and then asked to present back to us along with evidence of research into competitors and financials. There was a lot of ideas and we settled on a winning team who chose to utilise AI to create images (and unbeknownst to me at the time to create certain text passages). There was an assumption…

    » Read more

  • Lewis goes to MVP Summit

    April 23rd, 2025 in Blog, Business, careers, Community

    Introduction Attending the MVP Summit is a dream come true for many tech enthusiasts and community leaders. As a Microsoft Most Valuable Professional (MVP), I had the incredible opportunity to participate in this exclusive event this year, held annually by Microsoft. The summit brings together MVPs, Regional Directors, and select Gold Microsoft Learn Student Ambassadors from around the world, offering a unique platform to engage directly with…

    » Read more

  • Replacing Nested IFs with SWITCH() functions in DAX

    April 17th, 2025 in Blog, DAX, Power BI

    When solving problems and requirements for reports in Power BI, there eventually comes a need for nested IF() statements in your DAX. They work just fine, until they don’t. The more conditions you add, the harder they become to read, maintain and debug. There’s a cleaner way to handle this kind of logic and it’s one that often gets overlooked: SWITCH(). Let’s take a look at why it’s worth getting familiar with and how it can make your…

    » Read more

  • Verifying Potentially Stolen Passwords 

    • Change the Power BI Partner Logo to a vector instead of an imageApril 3rd, 2025 in Blog, Purple Frog Systems, SQL, SQL Server

    You’re currently being DDoS’ed and receive a ransom note. The attackers claim they’ve hacked your system and provide a list of usernames and passwords as “proof”. But did they really breach your system, or are they bluffing? Let’s investigate by checking the list against the database of hashed passwords.  Retrieve the Stored Password Hash from the database DECLARE @StoredPasswordHash VARBINARY(64) =…

    » Read more

  • From Practical to Impactful: Using Base64 Encoded Images to Transform Power BI Button Slicers

    From Practical to Impactful: Using Base64 Encoded Images to Transform Power BI Button SlicersMarch 25th, 2025 in Blog, Dashboarding and Reporting, Microsoft Fabric, Power BI

    Slicers are a key component within a Power BI report. They enable the user to intuitively explore their data and interact with visuals to reveal insights and patterns. The Button Slicer is a great choice to elevate the interactivity of a report whilst also boosting the visual impact, as it can be customized in a multitude of ways. In this blog I will show you how to use images in your Button Slicer to take your Power BI reports to the next…

    » Read more

  • Transform Your Data Strategy: Why You Should Migrate to Microsoft Fabric

    March 24th, 2025 in Blog, Fabric, Microsoft Fabric

    Microsoft Fabric Migration offers several compelling benefits for organisations looking to enhance their data management and analytics capabilities 📊 Here are some key reasons why you should consider the transition: 1. Unified data ecosystem Microsoft Fabric consolidates diverse data toolsets into a single integrated service. This means you no longer need to juggle multiple tools and platforms. Fabric provides a comprehensive solution…

    » Read more

  • Stop Pressing Publish in Power BI – OneDrive or Sharepoint can do that for you

    March 12th, 2025 in Blog, Power BI, Purple Frog Systems

    If you’re still using the Publish button in Power BI Desktop, there’s a better and more efficient way to manage your reports while saving time. By leveraging OneDrive and SharePoint integration, you can speed up your workflow, reduce errors, and improve collaboration. Here’s how you can do it: Step 1: Enable Save to OneDrive and SharePoint Preview Features First, ensure that your Power BI Desktop is set up correctly: Open Power BI Desktop.…

    » Read more