Tag: Power Query

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[…]

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[…]

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

Posted on by Reza Rad

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 about Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI[…]

Add Photos to Power BI from Active Directory

Posted on by Philip Seamark

If you work for an organisation that stores thumbnail images of staff inside Active Directory, you can probably access these and incorporate the images in your Power BI Reports.  This is a great way of making an internal staff report look fantastic – and it’s easy! Step 1. Click Get Data from the Home tab Read more about Add Photos to Power BI from Active Directory[…]

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 on by Reza Rad

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 about 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[…]

Creating Machine learning Development and Production Environment in Power BI

Posted on by Leila Etaati

  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 about Creating Machine learning Development and Production Environment in Power BI[…]

List.Accumulate Hidden Gem of Power Query List Functions in Power BI

Posted on by Reza Rad

There are a number of List transformations available in Power Query’s graphical interface. However, the number of functions in the graphical interface is very limited. In this post, I’m going to explain about a function that is really powerful and is not yet listed in the graphical interface. List.Accumulate is a function that loops through Read more about List.Accumulate Hidden Gem of Power Query List Functions in Power BI[…]

Basics of Value Structures in M – Power Query Formula Language

Posted on by Reza Rad

A couple of months ago, I’ve written a blog post about Basics of M and explained few basics about this language. In this post, I’m going to the next step and will explain few other structure definitions in this language. In this post, you will learn about Tables, Records, Lists, and how to navigate through Read more about Basics of Value Structures in M – Power Query Formula Language[…]

Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays

Posted on by Reza Rad

In last two steps you learned how you can create a date dimension that has calendar columns, and fiscal columns. In this step we are going to look at how Power Query can be leveraged to fetch public holidays live from APIs, and add that information into the date dimension. This step shows the importance Read more about Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays[…]