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

Road Map to use Microsoft ML tools

I normally work with most of the Microsoft tools for the aim of doing machine learning. I came up with a roadmap that shows what option for machine learning we have with Microsoft tools in Data Platform. this roadmap is not completed yet, I need to update it one later with some tools such azure ...

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-Part2

In the last post, I have explained how we can create a function with the aim of parametrising the machine learning process. In this post, I am going to explain how we able to create a Development and Production environment. Create Different Environment in Power Query to create a new environment, In power query, I ...

Read More

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

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

Basics of Value Structures in M – Power Query Formula Language

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

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

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

Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns

In step 1 of creating date dimension I explained how to create the base query with calendar columns. In this post I will explain how to add fiscal columns calculated in the date dimension. Many of business reports generates on fiscal year, fiscal quarter, and fiscal period, so having fiscal columns is important part of ...

Read More