Login or Sign Up to become a member!
LessThanDot Site Logo


A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "power query"


Overview of Published Articles – 2015Q2

Here is an overview of the articles I published in the second¬†quarter of 2015. INTENSE SCHOOL Book Review: Query Tuning & Optimization by Benjamin Nevarez MSSQLTIPS I’ve been busy writing tips! Purging Entity Members in SQL Server Master Data Services Using the Transaction History in SQL Server Master Data Services Introduction to Power Query for […]


Doing a Full Outer Join in Power Query

A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of ¬†the Microsoft BI platform is demonstrated alongside client testimonials. I gave a session called “Drilling across Analysis Services cubes using Power Query”, which talked about how you can use Power Query to do a […]