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