Category: Power Query

A Quick Overview On Different Power Query Tools In Power BI

A Quick Overview On Different Power Query Tools In Power BI - Enterprise DNA

Power Query is a powerful tool in data transformation. After understanding about the ribbons and panes found in the Query Editor, the next step is getting acquainted with its various features. In this tutorial, we’ll go over a quick overview on the different Power Query Editor tools that’ll assist you in organizing your data. Power

Continue reading

Power Query Optimization: Reducing Decimal Numbers

Power Query Optimization Reducing Decimal Numbers - Enterprise DNA

In this tutorial, you’ll learn a Power Query optimization technique to reduce RAM usage. Specifically, you’ll learn how to reduce the numbers stored after a decimal place. This is helpful if you’re dealing with columns stored in a decimal number format. In this example, you can see that the Net Price is consuming 11MB of

Continue reading

Overview Of The Query Editor User Interface In Power BI

Overview Of The Query Editor User Interface In Power BI - Enterprise DNA

The Query Editor in Power BI is designed to help the user apply most of the common transformations by interacting with a set of ribbons and menus. In this tutorial, you’ll learn how the query editor is organized. Knowing your way around the user interface will help you become more efficient. The Query Editor In

Continue reading

What Is Power Query & M Language: A Detailed Overview

What Is Power Query & M Language A Detailed Overview - Enterprise DNA

In this tutorial, you’ll learn about Power Query and the M language inside the Power BI desktop. Although there can be slight differences, you can apply the same general techniques across other Microsoft products like Excel, Analysis Services, and other Microsoft tools with an embedded Power Query Engine. What Is Power Query? Power Query is

Continue reading

How Data Segmentation Works In Power BI

An Overview on Data Segmentation In Power BI - Enterprise DNA

In this tutorial, you’ll learn about the basic concepts of data segmentation in Power BI and SSAS. Specifically, you’ll learn about the operational definition of data segmentation and its advantages. An Overview On Data Segmentation When you import data in Power BI, you need to click the Close & Apply option. In the case of

Continue reading