How to see what the actual values are in a FILTER when using a DAX Measure
I was working with a customer trying to get them to better understand DAX and one if the things that is difficult to understand is how the filtering works in DAX. The challenge I have found is that when using filters in a DAX measure I cannot visually see what is happening within the DAX Filter. Below I will show…
Power Query – Add Column to see if it is a Number Data Type
I was recently extracting some data from a web page and I wanted to remove all the rows that did not have a Numeric or Number value. I solved it by doing the following below. The column I was using was called ironically Column5 The syntax below can be used in Power Query / Query Editor to see if the…
Power BI – Bulk Changing Permissions (Read, Reshare & Build) on Datasets
I recently had a challenge where a report was shared with a whole lot of people (Which is a good thing!). The challenge was that when you share reports, by default it has the option to “Reshare” as shown below. Whilst this sometimes is what is required, I always suggest to people to remove this option and rather manage it…
Did you know you can use the Scheduled Cache Refresh for LiveConnections in Power BI to tell you if it is down?
Did you know you could use the Scheduled Cache refresh to notify you if your Live Connection is down between Power BI and your SSAS/AAS Database? In this example below I already have got my reporting connecting to an Azure Analysis Services database, this could also be an On-Premise SQL Server Analysis Services database. I make sure that I first…
Using Power BI Support to create a Support Ticket
Whilst I have been busy answering questions on the Power BI Community one of the things that I have found is that at times people with Power BI Pro or Power BI Premium are unsure where to create a support ticket which will allow them to escalate their issues. Below I explain how to do this. Creating Support Ticket The…
Power Query – Getting the Min Value repeated for all rows in my table
I was working on a side project, looking to track how I had been training in Strava (Yes, I am a M.A.M.I.L. for anyone who has been to my presentations would have seen the picture!) What I was looking to do was to get the starting time of my event repeated on every row, which would then allow me to…
How to enable the Power BI On-Premise Data Gateway to Stream data immediately
Below is a quick blog post on how to stream the data immediately when using the On-Premise Data Gateway. Currently as far as I understand it the On-Premise Data Gateway will wait and buffer some data before sending it through to the Power BI Service. By changing the setting below in the On-Premise Data Gateway, it will start streaming the…
Hiding the Filter Pane on opening a report or in Full screen mode in Power BI
I was answering a question on the Power BI Community where a user was having a challenge when opening a report in Full screen mode and it kept on expanding the filter pane. This report was only going to be run in full screen. Below are the steps on how I solved the solution. I solved it by doing the…
Creating a Time Dimension using the Power Query Editor in Power BI Desktop
Below is the syntax to create a Time Dimension Table in Power Query I had a requirement where I needed to create a Time Dimension for a customer. Most of the time I only need the date. Upon searching I could not find a resource where they had created the time dimension only using Power Query. Reference: https://docs.microsoft.com/en-us/powerquery-m/list-times What I…
Using Azure Analysis Services to connect via an ODBC Source (Redshift)
I am busy working with a customer and had a challenge when using Azure Analysis Services to connect to Amazon Redshift via an ODBC connection. The first issue that I encountered was the following error: OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application; AWS PROD. This lead me…