Call today 0845 643 6463

Tag Archive: Power BI

  • 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

  • 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

  • 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: Grouping & Binning using Data Groups

    September 12th, 2023 in Blog

    In this blog, we explore Power BI’s Data Groups feature, enhancing data visualization and interaction for report users. Data Groups in Power BI: Power BI’s Data Groups efficiently organizes data. Compared to lengthier alternatives like grouping in Power Query or DAX Calculated Columns. Binning Data for Visualization: Let’s discuss data binning for clearer visuals. Binning categorizes data into bands or ranges. For instance in…

    » Read more

  • Automate Power BI single table refresh using Azure Synapse Analytics and Power BI APIs

    August 23rd, 2023 in Azure, Blog, Power BI, Synapse, Tabular

    In a blog I posted back in June 2022, I explained how you could trigger a Power BI dataset refresh via Azure Synapse Analytics. https://www.purplefrogsystems.com/2022/06/how-to-trigger-a-power-bi-dataset-refresh-via-azure-synapse-analytics-in-3-simple-steps/ However, what if you just wanted to refresh a select number of tables or objects rather than a full dataset? This might be the case if you are performing intraday loads in your ETL. There…

    » Read more

  • Power BI – Recalculate / Refresh a Calculation Group

    June 20th, 2023 in Blog, Power BI

    In Power BI, when working with calculation groups, they will often need to be recalculated when certain changes are made. You will end up with this error message if you use a calculation group that’s been changed in your Power Bi Report: The query referenced Calculation Group Table ‘Calculation Group’ which does not hold any data because it needs to be recalculated or refreshed.   Thankfully, the solution to this error is quite simple…

    » Read more