Call today 0845 643 6463

Power BI

  • How to export more than 30,000 rows of data from Power BI Desktop.

    June 21st, 2021 in Blog, DAX, Power BI

    Have you ever wanted to export a table from Power BI Desktop into Excel just to make sure the DAX you’ve written is performing as expected but ran into this error message: “Data exceeds the limit – Your data is too large. Some data sampling may occur”? Most probably this has occurred because you’ve got more than 30,000 rows of data in your table that you’re trying to export. In the example shown below I’ve actually got 30,001 rows…

    » Read more

  • Dynamic Date Formats in Power BI

    May 7th, 2021 in Blog, Power BI, Uncategorized

    Which date format styles should we use if we are building a report that is being consumed internationally? Remember, 01/12/2021 is December 1st or January 12th depending in which part of the world it is being read. The decision may be taken from our hands if there is a company policy in place. If the company is based in the USA, for example, they may choose to use US formatted date fields as a standard for reporting across the entire business,…

    » Read more

  • Power BI – Enable Load

    April 16th, 2021 in Blog, Business Intelligence, Power BI, Uncategorized

    In Power BI Power Query there is an option to enable or disable whether a table is loaded into the report. The option ‘Enable load’ can be found by right clicking on the table. Typically, by default, the load is already enabled. There is also an option ‘Include in report refresh’ which lets a user stop a table from refreshing when they refresh the entire report. This maybe useful for static tables or tables that are large which take a…

    » Read more

  • How to make your matrix column widths all equal to each other in Power BI using DAX.

    April 9th, 2021 in Blog, Power BI, Uncategorized

    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

  • Power BI Drill Through using Multiple Data Points

    February 23rd, 2021 in Blog, Power BI

    A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitation of the drill through functionality is that it only allows users to drill through on a single data point. If more than one is selected, the drill through…

    » Read more

  • Tabular Cube Processing Report

    December 9th, 2020 in Analysis Services, Blog, Business Intelligence, Power BI, Tabular, Uncategorized

    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

  • Speaking at Data Platform Summit

    August 20th, 2020 in Blog, Community, Machine Learning, Power BI

    I’m delighted to have been selected to speak at the Data Platform Summit (DPS), a virtual conference from 2nd to 4th December 2020, with Data, Analytics and Machine Learning content around the clock for a global audience. I’ll be presenting a session on “Machine Learning in Power BI”, exploring various methods of accessing Machine Learning functionality within the Power BI world, including text analytics, prediction…

    » Read more

  • How to block the creation of a classic workspace in powerbi.com when a new MS Team is created!

    August 18th, 2020 in Blog, Business Intelligence, Power BI

    There is now a new tenant setting for Power BI admins to prevent users from creating classic workspaces in Power BI! This includes from places like MS Teams! Hurrah! If you’re a Power BI Admin you can now enable ‘Block classic workspace creation’. To do this go to the powerbi.com portal and click the ‘settings’ icon in the top right hand corner of the screen. Click on ‘Admin portal’ and then locate and…

    » Read more

  • SSAS Tabular Calculation Groups – avoid using SELECTEDMEASURE or ISSELECTEDMEASURE

    June 17th, 2020 in Analysis Services, Blog, Power BI, Tabular

    Introduction: There is a very serious limitation in the behaviour of calculation groups when using the SELECTEDMEASURE or ISSELECTEDMEASURE functions, and we recommend not using them. Why? If a user creates their own custom calculations within their Power BI report (or composite model) then the value of SELECTEDMEASURE changes, breaking your calculation group logic. Let me explain with an example: In a tabular cube we may look to use calculation…

    » Read more

  • Using ConcatenateX in PowerBI to return multiple values.

    June 9th, 2020 in Blog, Business Intelligence, Power BI

    In this blog post we’ll take a quick look at using ConcatenateX function to view a concatenated string of dates where the max daily sales occurred for a given month. I came across this function whilst going through the excellent “Mastering DAX 2nd Edition Video Course” by the guys from SQLBI.com. So credit to Marco and Alberto for sharing this. So how does it work? If we had a list of dates ranging from 01/01/2020 to 31/12/2020 and we…

    » Read more