Call today 0845 643 6463

PowerBI

  • Using Synoptic Panel to Create Data-Driven Diagrams in Power BI

    January 20th, 2026 in Blog, PowerBI

    Introduction Power BI is fantastic for visualising geological data, with the latest Azure Map visual providing some further enhancements on top of previous map visuals (pathing, traffic layers etc.) However, what if there was a need to drill-down a little further into a location. For example: What if we wanted to understand how product positioning within a store might be affecting sales. Or maybe, we own a vehicle maintenance workshop and wanted…

    » Read more

  • Is ETL now a Circular Process?

    December 24th, 2025 in Blog, Business Intelligence, Data analytics, Microsoft Fabric, Power BI, PowerBI

    Traditionally, ETL (Extract, Transform, Load) has been a one-way journey. Data is extracted from operational systems, it’s transformed into a clean, structured format and then it’s loaded into a data store (typically a warehouse or lakehouse), rinse and repeat. But what’s after that? Business users build reports and dashboards and make a decisions from their insights, but the data itself never flows back into the systems where the work…

    » Read more

  • Fill Blank Rows With Previous Non-Blank Values – DAX

    Fill Blank Rows With Previous Non-Blank Values - DAXSeptember 5th, 2025 in Blog, Business Intelligence, Dashboarding and Reporting, DAX, Power BI, PowerBI

    Fill Blank Rows With Previous Non-Blank Values – DAX I want to see a value for everyday, whether a new value exists or not – lets call it tracking the members of a golf club. If there are no changes to the member numbers, I would have no movement figure on that day. If someone joined or left, the figure would be updated. Just because there are no changes, it doesn’t mean that there are no members on that date and therefore this day is…

    » Read more

  • Overcoming Direct Lake Connection Hurdles

    January 7th, 2025 in Blog, Data Lakehouse, Data Warehouse, Fabric, Microsoft Fabric, PowerBI

    I love organising. When it comes to Microsoft Fabric, I am no different. The addition of files was a heaven-sent for me as I could finally clear up the clutter and make a Fabric solution user friendly to navigate. This allows my end users to access the correct information when they need it, quickly and accurately. Majority of the time, the end user does not need to access the Data Warehouse or Lakehouse that is storing their data, but rather the…

    » Read more

  • Power BI Dataset Gives Mashup Timeout Error While Refreshing

    July 26th, 2024 in Blog, Data Warehouse, Power BI, PowerBI, SQL, SQL Server, Uncategorised

    Help – my Power BI dataset is giving mashup timeout error on refresh The mashup timeout error Incremental refreshes are a great benefit to have in order to reduce refresh times – but not when they give a mashup timeout error. Although they are meant to be a performance enhancement, they aren’t always the best approach as they fire parallel queries to the source and apply date time filters. Despite the default timeout being 2 hours, or 5…

    » Read more

  • Using Stored Procedure as a Power BI Source (with parameters)

    April 9th, 2024 in Blog, Business Intelligence, Power BI, PowerBI, SQL, SQL Server

    Using a SQL Server stored procedure as a source in Power BI We might be most familiar with using a view as the source to our PBI datasets, a series of views creating a series of tables. This can be great but when handling more complex view queries with lookups, you might find yourself with a severely long refresh and even an error. This is where a stored procedure is required – this gives you more control layer by layer in the source query.…

    » Read more

  • Automating DAX Measure Formatting in Power BI with Tabular Editor

    January 8th, 2024 in Blog, DAX, PowerBI

    Until coming across this piece of code, I often used the DAX formatter (https://www.daxformatter.com/) to format all of my Tabular Model measures. However, if you end up writing a lot of measures in your Tabular Model this can become quite tedious. There is a faster method however. Using Tabular Editor 2 and some basic C# code you can format all of your Tabular model measures at once. Assuming you have Tabular Editor 2 installed on your machine,…

    » Read more

  • Introduction to Power BI Project Files

    October 24th, 2023 in Blog, Power BI, PowerBI, Uncategorised

    Power Bi project files were showcased as an exciting upcoming feature by Microsoft for Power Bi. Developers can finally smile as it allows significantly easier collaboration with other developers and source control within Power Bi. We’ll go through a brief introduction to Power Bi Project files.     How to get a Power Bi Project File At the writing of this blogpost they are currently in preview and can be accessed via the ‘Preview…

    » Read more

  • Power BI Table Totals Not Adding Up? Here’s Why!

    Power BI Table Totals Not Adding Up? Here's Why!October 4th, 2023 in Blog, DAX, PowerBI, Uncategorised

    Ever built a table containing measures in Power BI, done a quick sanity check on your table totals and noticed they’re incorrect? Let’s explore why this may be. Here we have a simple table, built from data in the AdventureWorks database. It shows the three product categories, the Total Sales and Average Order Total of each category: As you can see, the Total Sales column adds up perfectly, but the average is just plain wrong. 19.42 +…

    » Read more

  • What is Microsoft Fabric? (Power BI + Synapse + DW + DataLake + ML)

    What Is Microsoft FabricMay 23rd, 2023 in AI, Big Data, Blog, Business Intelligence, Data Factory, Data Lake, Fabric, Power BI, PowerBI, Spark

    At today’s Build conference, Microsoft announced Fabric. What is this? In simple terms, think of taking Synapse Analytics, Data Warehousing, Data Lakes, Data Factory, Spark Notebooks and Machine Learning, and bring them all together into Power BI. This is underpinned by Microsoft OneLake, a high performance scalable data lake storage layer, supporting all of the above. OneLake is, as the name implies, one data lake that can be used across…

    » Read more