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

Power BI and Azure ML make them work with Power Query

In this blog post, I am going to show how to use the Azure ML web service in Power BI (Power Query). First Step: You need to create a model in Azure ML Studio and create a web service for it. The traditional example in Predict a passenger on Titanic ship is going to survived ...

Read More

Cognitive Services in Power BI

Microsoft Cognitive services are collections of API and services that help developers to create more smart applications and reports.  By using Cognitive services, developers able to add intelligence features such as face recognition, emotion recognition, text analytics and so forth into their applications. Cognitive Services Overview There are different cognitive services available that you can ...

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