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…
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…
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…
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…
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…
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…
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….
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…
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…
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…