Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold

After a long wait, in the October 2018 release of Power BI Desktop we saw the fuzzy matching feature added finally. Yay! Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is ...

Read More

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

Posted by on Aug 27, 2018 in Power BI Helper, Power Query | No Comments

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

Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI

Sometimes for tables with too many columns, and also for databases with too many tables, you do need a bit of help to explore the data. As an example; you know that you are looking for a column named “account status”, but the column does not exists in the accounts table. You need to search ...

Read More

Export the Entire M Power Query Script from a Power BI File, New Version of Power BI Helper, Search based on Field Description in the Model

Posted by on Jan 29, 2018 in M, Power BI, Power BI Helper, Power Query | No Comments

Previous versions of Power BI Helper had some features related to the visualization part and the modelling part of a Power BI file. This latest release of Power BI helper, can export the entire M or Power Query script into a file or into clipboard. Sometimes, especially when the number of queries in the Power ...

Read More

Creating Machine learning Development and Production Environment in Power BI

  There is need to isolate the development and production environment in most of all projects. Setting up these environments help us to deliver a more reliable product to our customers. Machine learning projects also need a development, Test and Production environment. In this post, I am going to show you how we can do ...

Read More