Call today 0845 643 6463

Power BI

  • Matt and Tom Ace Their Microsoft Exams!

    Matt and Tom Ace Their Microsoft Exams!November 9th, 2024 in Azure, careers, News, Power BI

    We’re thrilled to announce that two of our talented team members, Matt and Tom, have recently achieved significant milestones in their careers by passing their Microsoft exams! Tom successfully conquered the DP-600: Designing Data Engineering Solutions on Azure exam, demonstrating his expertise in designing and implementing robust data engineering solutions on the Azure platform. Matt aced the PL-300: Microsoft Power BI Data Analyst exam,…

    » Read more

  • Deep Dive into Power BI & Fabric Governance at PASS Data Summit

    Deep Dive into Power BI & Fabric Governance at PASS Data SummitNovember 7th, 2024 in Community, News, Power BI

    We’re thrilled to share that our very own Joe recently took the stage at the PASS Data Summit to deliver an insightful session on “BI the Book: Governance, Auditing, and DR for Power BI & Fabric”… Featuring Power BI Sentinel! Why governance matters… Data governance and security are often overlooked in the initial stages of building a data environment. However, neglecting these crucial aspects can lead to…

    » Read more

  • My Experience at Fabric Community Conference Europe 2024

    October 1st, 2024 in Blog, Data Lakehouse, Data Warehouse, Fabric, Power BI

    Stockholm: A city of charm and innovation Let’s start with the location, Stockholm. As a seasoned traveller, Stockholm is one of the few major European cities that I have not yet visited. So, when given the chance to go to FabCon Europe, I jumped at the chance. Stockholm is a great city, with beautiful historic architecture mixed with modern innovation and the people there were friendly and warm. The conference centre, the Stockholmsmässan,…

    » 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

  • Integrate Power BI with Microsoft Teams

    Integrate Power BI with Microsoft TeamsJuly 12th, 2024 in Blog, Power BI

    Quick post about a feature you might not be aware of; Power BI can work within Teams! Why integrate Power BI with Microsoft Teams? Integrating Power BI with Microsoft Teams can: Enhance collaboration: Teams can share, reference and discuss insights from Power BI reports, directly within the context of their conversations. Improve accessibility: Reports and dashboards can be easily accessed within Teams, eliminating the need to switch between…

    » Read more

  • Learning through ‘Unconventional’ Power BI Projects

    Learning through ‘Unconventional’ Power BI ProjectsJuly 1st, 2024 in Blog, DAX, Just For Fun, Power BI, Power Query

    When we think of Power BI projects we typically think of solving business problems through creating insightful analytical reports and dashboards, Power BI is fantastic for this. However, when trying to expand your knowledge on the functionality of Power BI, I have found it incredibly useful to think outside of the scope of these types of project and explore other ways to use it. In this blog I will show an example of an unconventional Power BI…

    » Read more

  • Fabric Trials: The Countdown Is On

    May 21st, 2024 in Azure, Blog, Fabric, Power BI

    We are drawing near to the end of Microsoft Fabric trials! ⌛ With the countdown ending mid-June for many trial capacities, it is important that you take measures to protect any Microsoft Fabric resources you have. Microsoft have informed users that once the trial ends, the capacity will be converted to a Power BI Premium capacity where Fabric items can no longer be used or stored. From here, you will have a 7 day retention period before all…

    » Read more

  • Quick Guide to Transition Power BI Reports to Power BI Paginated Reports

    April 30th, 2024 in Blog, Power BI

    A Quick Start Guide to Transitioning Existing Power BI Reports to Power BI Paginated Reports Why move a PBI report to Paginated Reports? The Use Case of Paginated Reports Paginated reports offer powerful features that regular Power BI reports may not fully address. When you encounter requirements like print-ready documents or data grids that overflow across multiple pages, paginated reports are the solution. Here’s why they’re essential:…

    » 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

  • Deployment Pipelines in Power BI and Fabric

    March 27th, 2024 in Blog, Fabric, Power BI

    Deployment Pipelines in Power BI and Fabric were released in public preview way back in May 2020 and then made Generally Available in September 2020. Even with how long they have been out, I rarely see them talked about when they are a very handy tool for Developers to ensure reports and Fabric content are safely moved between workspaces. Plus it provides some helpful tools for collaborating with other developers. Let’s look into how…

    » Read more