Power Query – How to get the output from a table as a value or an item
I was working on a customer’s data where I wanted to get the output from a table, but have it stored as a value or item. I am sure that in the comments there might be a possible way to do this more efficiently, but below is how I solved this challenge. As always it is best to work through…
Power Query – How to extract data before and after delimiters
I had a requirement where I wanted to extract the data before and after the data as shown below. In order to do this, I created the following Custom Column with the syntax below. I did try and use the “Columns from Examples” but it did not work, because in my actual dataset some columns did not have the “(Data)”…
Power Query – Replacing Column Names with spaces in Camel Case Notation
I was working with a table with quite a few columns where the column names were using Camel Case Notation (ThisIsMyColumnName), and I did not want to rename them manually. I used the following Power Query Code below to let it do the column renaming and putting in the space for me. Thanks to @Excel_City for assisting me in finding…
#PowerBI RoundUp – Power BI Desktop release for Feb | Gartner Magic Quadrant | Service & Mobile Update for Jan | Petabyte-scale Analytics with Power BI & Azure | Incremental refresh & query folding | Premium Capacity Metrics Webinar
Well a lot has happened in the last week, with the desktop release (YAY!), and a whole host of other details. Read below for more details on what has been updated and from my perspective. Power BI Desktop Release for Feb Every month the awesome people on the Power BI Team release new features and this month is no different!…
Where can I find all the data sources for my #PowerBI report?
I have found that at times people get other Power BI reports and are not sure what data sources there are in the file. As well as which data sources are connecting to what? In this blog post below, I will show you where you can find all the data source details. In my sample PBIX I have connected to…
Are my DirectQuery Tables still in DirectQuery Mode, how to ensure they stay that way?
I have been doing some work with Power BI Composite models, and what I have found is that often the DirectQuery table can be changed to an Imported table. I personally feel that this blog post will be an important reference for me and hopefully others when you start to use Power BI Composite Models, to ensure that the DirectQuery…
Power Query – Changing DateTime columns data types to Date without specifying the column names
This blog post I will demonstrate how to change a DateTime column data type to Date dynamically. You might be wondering what I mean by dynamic, this means that I will not specify any actual column names. The code will find the column names based on their data type. For me this has been a challenge to get it working,…
The Complete Power BI Infographic – Update for Dec 2018
I recently had a look at my last version of my Infographic and I realized that I had not updated it for a few months and there has been a lot of incredible additions to the Power BI ecosystem. My infographic not only contains the details outlined below, but all the prior updates too. It is incredible to see how…
Converting Multiple Items into One Row in Power Query
I was working with some external data where I had a list of Australia postal codes, the challenge is that there are multiple suburbs that are part of one postal code. Below I am going to show you how I took the multiple suburb names and put them into a single row, which would then allow me to have a…
Multiple conditions for a conditional column in Power Query
I am often working on datasets where there is more than one condition for a conditional column. And whilst the GUI based Conditional column is really good, it currently does not have the capability for multiple conditions. In this blog post below, I will demonstrate how to achieve this. In my example below, I have a table that has got…