Power Query

Power BI – Fixing Dates from Sharepoint Lists (converting UTC Dates to Local Dates)
So the problem below was in relation to working with dates from a Sharepoint 2013 List, but the same technique should be applicable any time you want to convert UTC/GMT datetime fields to a local time. When Sharepoint exposes datetime values from lists using its REST API it converts them to the UTC timezone. I suppose a lot of the time this makes sense, specially if you are dealing with data entry across multiple time zones. But if you are just working in a single timezone this can be frustrating ......

Posted On Friday, February 1, 2019 2:22 PM | Comments (0)

Function Folding in #PowerQuery
Looking at a typical Power Query query you will noticed that it's made up of a number of small steps. As an example take a look at the query I did in my previous post about joining a fact table to a slowly changing dimension. It was roughly built up of the following steps: Get all records from the fact table Get all records from the dimension table do an outer join between these two tables on the business key (resulting in an increase in the row count as there are multiple records in the dimension ......

Posted On Friday, May 16, 2014 7:40 AM | Comments (0)

#PowerQuery – Joining to a Slowly Changing Dimension
I blogged previously about how to look up a surrogate key for a slowly changing dimension using DAX. This post is about how to do the same thing using Power Query. I'm going to start off with the same 2 tables that I used in the previous blog post. One is a fact table and the other is my BU (Business Unit) table. I started by clicking on each table of data in Excel and choosing the "From Table" data source option. And for each table I unchecked the "Load to worksheet" option and then clicked apply ......

Posted On Monday, May 5, 2014 9:53 PM | Comments (2)