Tag: advanced editor power query

Power BI Parameters Via Query Editor

Creating And Using Parameter

In this tutorial, we’ll discuss how we can create and use Power BI Parameters which is a powerful feature of the Query Editor.  There are instances when we want to put additional filters on our data within the query editor. We can do that by utilizing the Manage Parameters option within the Home ribbon. For this

Continue reading

Microsoft Power Query Tutorial On How To Fix Mixed Fixed Column Width Issues

Mudassir: For today, we have a very interesting problem to work with. The problem with this file is that it is fixed delimited by columns and I don’t know how to resolve this using Microsoft Power Query. You can watch the full video of this tutorial at the bottom of this blog. First, it wasn’t

Continue reading

Enter Data In Power BI: How To Use It For Data Entry

Enter Data In Power BI: How To Use It For Data Entry

In this blog post, I want to take a closer look at the Enter data in Power BI and show you ways how to use it. Before, in most cases, we brought in data by connecting to a data source. That won’t change of course, but Power BI also offers ways to manually create tables,

Continue reading

How To Use Power Query Row And Column Selection

How To Use Power Query Row And Column Selection

This tutorial will discuss how to use selection and projection inside the Power Query Editor. Selection is for selecting a row; projection is for selecting a column. You’ll learn and understand how to use them to obtain data and information from a table. How To Use Power Query Row Selection The positional index operator is

Continue reading

Power BI Values And Literals – Understanding The Basics

Introducing-Values

In this tutorial, you’ll learn about Power BI Values and how they are generated inside the Power Query Editor. These values have corresponding literals that can be used in codes and expressions to produce results and data. You’ll also learn how and where to apply the values to build a compelling report. Power BI Values

Continue reading