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.

I love automating things, I have read somewhere, a good developer always tries to automate things, but in my case, I…

Have you ever ended up in a situation where someone already did all the work to get the right brand colours,…

Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always…

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

When it comes to writing, I have the least trust in my writing skills. I always wanted my blog to sound…

If you are the goto person for Power BI in your organisation, then I am sure at least once you may have…

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

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

So far I have seen many Power BI usage metrics demo’s or read blog posts about usage metrics, but not actually…

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

I am a huge OneNote fangirl, most of the times I start my working day by opening OneNote. But yesterday I…

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

Update – There is already a dedicated function available to do this, Table.TransformColumnNames. Thanks Imke Feldmann for the shutout. You can…

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 was taken place on 16th – 17th of February at Hemel Hempstead, HERTS, UK. It was organised by…

Directories at different levels are critical for some organisations. One of the requirements I received recently was to import Flat Files from directories (…

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

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

October 1st, 2016, 03:00 PM. I was in our car with my family on our way to Harveys and email notification…