top of page
The Journal of My Work


Split multiple columns into rows in #PowerQuery
Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always…


Power BI Template to document the Power BI Service
Back in September, I promised I would write another blog post with a beautiful looking Power BI template. Even though I…


How I designed “Power BI Template to document the Power BI Service”
When it comes to writing, I have the least trust in my writing skills. I always wanted my blog to sound…


How to find all Power BI users in an organisation?
If you are the goto person for Power BI in your organisation, then I am sure at least once you may have…


Access Microsoft Graph API using Power BI
Recently I came across Microsoft Graph API through Power BI Custom data connectors documentation. Amazed by the amount of information provided…


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…


Validating Data using SSIS
I cannot believe it took me almost three months to recover from the house move. At last, I feel like I…


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…


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…


Working With Teradata Volatile Tables And ADO.Net Connection
While I am in the flow of blogging, I want to write about an issue which troubled me recently. It definitely…


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