Using Power BI to ensure Daylight Savings Dates and Times change dynamically
I was helping on the Power BI Community and it struck me that there currently was not a way to easily manage Dates and times for Daylight savings. In this blog post below, I will show how I achieved this by using parameters and little bit of M magic (Directly Editing the M Code). As part of completing this solution I…
Power BI – Using Functions for repeatability and can easily repeat Applied Steps to your data
In the past I did create a blog post where I demonstrated how to get the location of a user based on an IP Address What I did forget to elaborate on and what really makes Power BI even more powerful is how easy it is to create and use a function. So this is the goal of my blog…
Power BI – Power Query/Query Editor Automated Source Control
I saw a blog post recently where Jay Killeen was talking about how he handles his Source Control for the Query Editor or Power Query. And this got me thinking of how I could automate this in a quick and easy manner. So below is how I achieved this. My solution below, uses a BAT file and 7zip, which means…
Power BI – Getting your report to always filter this month’s data dynamically
I had a requirement where I needed to have the capability to set the filter once on a report for the current month and then it dynamically move as each month progresses. I will show how I completed this in the steps below. NOTE: As with almost all Power BI Models, this is going to be leveraging off my Date table…
Power BI – Why creating columns in the Query Editor is better, quicker and more efficient than creating Calculated Columns.
I have been reading and helping out where I can on the Power BI Community forums. And what I often see is people trying to use the Calculated Columns in the Power BI Desktop Model. So in this blog post below I am going to explain why it is better, quicker and more efficient to use the Query Editor to create additional columns….
Power BI – Quick Tip – Overcoming additional columns in CSV or Flat Files
This quick tip explains how to overcome an issue with using CSV or Flat Files and you get additional columns. I have been working with CSV Files, and what often happens is that you get years added into the columns on a CSV File as shown below is what the original file looks like. And this is what the source…
Power BI – Using Parameters for Flat File / CSV / Excel Sources
I was recently catching up on Blogs as I always find this a wealth of information and it often leads to me learning something new. Which I can then leverage in my current work environment and this is one of those cases. This is to show how using Power BI and the built-in Parameters it can be capable of handling…
Power BI – Quick Tips working with multiple large CSV Files
I have recently been working a lot with multiple larger type CSV files, and thought it would be good to share what I have found that makes the process run faster. I am always looking at ways to make sure that not only is the model efficient, but also the development experience. Name your query first before applying steps in…