top of page
The Journal of My Work
October and November #LondonPUGDataViz – UK Price Paid Data
My Power BI journey started with this dataset. Probably one of the most reliable open data source. Nicely formatted and very…
PowerApps and Sharepoint List-Identify which detail item has already been updated in PowerApps?
In one of my recent project, I did a fair bit of PowerApps. PowerApps was the front end, Share point list…
Dynamic Period variance with DAX in #PowerBI
One of those days where I spent a reasonable amount of time trying to solve a tricky DAX expression and once…
List.Repeat() in #PowerQuery to duplicate rows
Another quick, more of “Note to self” blog post. While I was working with FIFA Football Model, one of the queries…
Mass shooting data
For this month #LondonPUGDataViz, we are going to play with Gun violence archive data. This data is very interesting because it…
Adding a vertical line or marker to a chart in Power BI
A business user came to me asking “how can I get a vertical line on Line Chart in Power BI like…
Replace all numeric values in multiple columns using #PowerQuery
Learn how to replace all numeric values in multiple Power Query columns at once. A practical M language solution for data transformation in Power BI.
#PowerBI Audit log using #Office365 Management API
I love automating things, I have read somewhere, a good developer always tries to automate things, but in my case, I…
Where is my Power BI theme file?
Have you ever ended up in a situation where someone already did all the work to get the right brand colours,…
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…
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…
PowerBI Embedded with OneNote
I am a huge OneNote fangirl, most of the times I start my working day by opening OneNote. But yesterday I…
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…
bottom of page