Power BI Visuals now support Custom Formatting for measures using Calculation Groups!
The Power BI team has been doing a lot of incredible work. The most recent update which I got wind of is Custom Formatting of measures is now supported for Visuals. This has already been deployed to the Power BI Service and if you download thelatest version of Power BI Desktop (Version 2.83.5894.961 as at 03 Aug 2020) it has…
Did you know you can query data from AWS S3 into Power BI?
I really enjoy a good challenge, and with my customer they have all their data stored in AWS S3. Whilst there is no native connector, I thought there must be a way for me to get the data from AWS S3 into Power BI. I did a bit of Googling and could not find any suitable solution. I also found…
Validating Power BI DAX measures when using Tabular Editor
I have really enjoyed using Tabular Editor with Power BI, as announced in the latest version of Power BI Announcing public preview of external tools in Power BI Desktop One of the challenges I have found is that it is very easy to create a new measure in Tabular Editor. Due to it currently not having any Intellisense I have…
Showing Dates in reverse order for Tables/Matrix with dates, so that the latest is always shown first in a Power BI Matrix
While doing some work I had a matrix that I had created. What I found was that when I had more Yr-Month values that could fit in the matrix due to having the scroll bar it would show me the older Yr-Months and not the latest ones as shown below. I always like to think what the experience would be…
How to configure Incremental Refresh with Power Query in Power BI
Following on from my successful blog post How you can incrementally refresh any Power BI data source (This example is a CSV File), I found a way where I can just use dates created in Power Query to get data refreshing incrementally. Full credit goes to Rafael Mendonç who actually figured this out. All that I have done is to…
Getting the correct Date Format to be displayed in the Power BI Service
Lately on the Power BI Community I have noticed people having issues with the date format not showing correctly. I thought I would post the steps on how to achieve this below. This is how my date was formatted before making the changes below NOTE: Before starting make sure you have saved and closed all your work. I had…
Power BI On-Premise Data Gateway Error: DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1
I got the following error DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1 This error was caused because the current Virtual machine where the On-Premise Data Gateway was running was cloned and then started up. The result was that this then caused the Power BI Service to not correctly connect to the valid Gateway. The reason is that there were 2 servers running, with the same name,…
How you can incrementally refresh any Power BI data source (This example is a CSV File)
How you can incrementally refresh any Power BI data source (This example is a CSV File) I was reading the awesome blog post by Dustin Ryan (POWER BI INCREMENTAL REFRESH WITH WEB API DATA SOURCE) and what I saw him do gave me an idea, is it possible to configure a CSV file to be incrementally refreshed using a similar…
Did you know you can now selectively show report pages for specific users in Power BI?
With the update to the latest version in Power BI Desktop there is now the capability to control which users will see which pages in a report. This is achieved using a combination of Row Level Security (RLS) and conditional formatting. This makes it a secure way of controlling access for specific users. I will demonstrate how this works below….
How to fix Power BI Slicer Items that are not clickable because there are too many Visual Header Icons
Recently a user sent me a message saying that they could no longer click on a slicer item. I tried to myself and I had no issues clicking on the slicer item. I then had an online screen share with the user, so that I could see what was happening when they were trying to click on the Slicer item….