Month: August 2018

Beautify M Script and Extract Row Level Security with Power BI Helper Version 4.0

Posted on by Reza Rad

Power BI Helper is getting new features every time, and this time, we got some exciting features; You can now get your M (Power Query script) code beautified and colorful with version 4.0 of Power BI Helper. We also get the row-level security information exposed through the Helper application. Both information above will be now Read more about Beautify M Script and Extract Row Level Security with Power BI Helper Version 4.0[…]

Fun with DAX – Mission Impossible

Posted on by Philip Seamark

Further to my recent series of Power BI based games, I thought for this article I would build a version of the popular children’s game, Hangman.  To win the game, you need to guess a hidden word letter by letter, with the user having a number of “chances” with each wrong guess bringing you closer Read more about Fun with DAX – Mission Impossible[…]

Find Mismatch Rows with Power Query in Power BI

Posted on by Reza Rad

Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may have customer records coming from two sources, and want to find data rows that exist in one, but not the other. In Power Query, you can use Merge to Read more about Find Mismatch Rows with Power Query in Power BI[…]

Watch Your Steps! Power Query Performance Caution for Power BI

Posted on by Reza Rad

I work with Power Query transformations every day these days, and I want to share one simple, but critical caution with you. If you use Power Query a lot, this tip can improve the performance of your transformation significantly. The number of steps that you add in a query counts in the performance of your Read more about Watch Your Steps! Power Query Performance Caution for Power BI[…]