Return Custom Error Message for Any Issue in Power Query

Video by: Reid Havens

Learn how to return custom error messages whenever any applied step in a Power Query query fails. More info about the m code function used to achieve this can be found below.

https://docs.microsoft.com/en-us/powerquery-m/error-record

Download Report From The Blog Files Page
Posted on January 7, 2020 by Reid Havens and filed under Intermediate, Power Query and tagged Power Query Commands M Code.

New Pages Added to my Google Analytics Report!

Video by: Reid Havens

Learn about the two new pages I added to my Google Analytics Report. One page is dedicated to the new Decomposition visual just released in Power BI desktop. The other page is dedicated to site speed information. More information about the decomposition tree can be read below.

NOTE: to use the decomposition tree, you need to enable that visual in the preview settings in the options menu.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree

Check out the GA Report in the Files Store
Posted on December 31, 2019 by Reid Havens and filed under Beginner, Power BI and tagged Reports to Purchase.

Multiple Ways to Apply Field Based Conditional Formatting

Video by: Reid Havens

Learn about three different color codes that can be applied to field based conditional formatting in Power BI desktop. Special thanks to Will Thompson on the Power BI team for showing me these options.

Download Report From The Blog Files Page
Posted on December 17, 2019 by Reid Havens and filed under Intermediate, Power BI Features and tagged Conditional Formatting Color & Formatting.