Published on March 21, 2018 at 02:09AM
Take the currently logged in user in PowerBI and filter data based on an attribute of the User table
Published on March 08, 2018 at 11:07PM
Users logged into PowerBI can have their email address exposed. This allows us to create dynamic row level security using inner joins on a user table.
Published on December 14, 2017 at 06:23AM
Just copy and paste this into a blank query and you will get a simple two column table with two rows.
Published on December 08, 2017 at 12:10AM
I regularly add a model to my Power BI or Power Query to represent the date and functions around date.
Published on June 21, 2017 at 12:51AM
Informally Known As WTF is M
Published on June 20, 2017 at 10:55AM
You read the brochure but you just can't get that hot tub workin'
Published on May 17, 2017 at 12:39AM
Very simple query to show when you last hit the 'Refresh' button in PowerBI
Published on May 03, 2017 at 04:33AM
This was useful when building a subsequent M Query and needed to know all available table column, types and keys
Published on April 05, 2017 at 04:53AM
Fixing bugs like "We cannot convert the value "[Table]" to type Table."
Published on March 20, 2017 at 12:33AM
A collection of the issues I run into day to day using the Query Editor along with the magic sauce to make it better
Published on March 06, 2017 at 06:18AM
Limit the amount of time you watch Power BI getting rows of data when you are working on your views
Published on March 01, 2017 at 12:54AM
Backing up and using version control systems are real things we should consider to save us from that next crash that is likely to occur
Published on February 23, 2017 at 07:22AM
Simply sum the quantity using a field from the current row as a filter in the table you are summing from
Published on February 23, 2017 at 07:21AM
Simply Count the
Published on February 21, 2017 at 01:18AM
Date's can get difficult to merge on other date or datetime fields. Use this function to convert to a DateKey or Date ID
Published on February 15, 2017 at 04:08AM
Reuse your code by pulling queries from web servers
Published on February 13, 2017 at 11:01AM
Just a simple reminder on how to do single and multiple line comments
Published on February 13, 2017 at 10:57AM
You know how to countif in Excel so why is Power Query so difficult?