Call today 0845 643 6463

Power BI

  • 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

  • Sorting a Power BI table by multiple columns

    May 29th, 2020 in Blog, Power BI, Uncategorized

    A common request that is raised by clients is how to sort a table in Power BI by multiple columns, in the same way you can in Excel.For a while, there was no way (at least no easy way) to do this until the Power BI March 2020 update. I learnt this tip from the following YouTube video:https://www.youtube.com/watch?v=ik0K1H9j2UcFull credit to Dhruvin Shah, check his video out. Below I have a Power BI table displaying fruit sales, currently…

    » Read more

  • Power BI Databricks Spark connection error

    May 19th, 2020 in Big Data, Blog, Cloud, Power BI, Spark

    When querying data from Azure Databricks (spark) into Power BI you may encounter an error: “ODBC:ERROR [HY000] [Microsoft][Hardy] (100) The host and port specified for the connection do not seem to belong to a Spark server. Please check your configuration.“ This is usually caused by trying to connect to a ‘Standard’ Databricks instance, but Power BI (and ODBC in general) can only connect to Databricks using a…

    » Read more

  • Creating calendar tables with DAX using Power BI

    April 6th, 2020 in Blog, Business Intelligence, Dashboarding and Reporting, Power BI

    By Nick Edwards In this blog post we’ll take a quick look at creating a self-generating calendar table using DAX. Dates are important if we want to perform time intelligence reporting on our data i.e. yearly sales, monthly sales, weekly sales, year to date sales or previous year sales. We’ll be using the calendar function to create our date table, but there are other methods to do this such as CALENDARAUTO or GENERATESERIES. Here is the…

    » Read more

  • Creating Power BI Layouts using PowerPoint

    December 2nd, 2019 in Blog, Power BI

    First question, why bother with layouts?Using layouts in Power BI allows a user to make their visuals stand out better, the page looks professional and more appealing to its audience. Second question, why PowerPoint?The default page size in Power BI desktop is 16:9, (this trick doesn’t work for other Power BI page sizes), which is identical to a PowerPoint slide.Therefore whatever is designed in PowerPoint will fit onto a Power BI page…

    » Read more