top of page
The Journal of My Work


SharePoint List Power BI Template
SharePoint is a killer; front end looks nice and beautiful. Once you start exploring behind the screens, that is when it…


Power BI Workaround – Drill Through Reporting in Power BI
So far I have seen many Power BI usage metrics demo’s or read blog posts about usage metrics, but not actually…


Power BI Workarounds – Clickable Card / Card Look-alike
Recently one of my business users came to me asking “how can I get a Clickable Card in Power BI”? He…


PASS BA Marathon – Compelling Visuals in Power BI
In my recent talk for PASS BA Marathon, I showed few formatting tricks in Power BI with my super slow laptop. I…


Modify Column Names Using Power Query M Functions
Update – There is already a dedicated function available to do this, Table.TransformColumnNames. Thanks Imke Feldmann for the shutout. You can…


Highlight a Specific Data Point using Power BI
For me, Stephen Few has always been the guru of Data visualisations. Recently, while I was reading one of his paper, I…


UK Power BI Summit – 2017
UK Power BI summit was taken place on 16th – 17th of February at Hemel Hempstead, HERTS, UK. It was organised by…


Find level of Directories / Find String in Power BI
Directories at different levels are critical for some organisations. One of the requirements I received recently was to import Flat Files from directories (…


Data story – Property search with Power BI
Don’t wait for the opportunity CREATE it. I was just trying to create an opportunity to work with Power BI; that…


Dimensional Modelling Workbook
A few years ago when I was searching for a free dimensional modelling tool, through some forum; I saw this fantastic Dimensional…


How to add extra columns to an existing Power BI file which has CSV as data source
Quick Power BI Tip: Case: How to add extra / new columns to an existing Power BI file which has CSV as…


Download And Unzip files using Power BI Desktop and R Script
Most of the open data source providers supply data in a compressed format, especially when files are large. That is what…


Twitter Analysis using SSIS 2016 and SQL Server R Services
After years of hesitation finally, I think I am ready to write my first blog post, or I should say I…
bottom of page