Custom column in Power BI
Power BI Custom column adds a new column in data model based on the existing columns in data model. You can create a custom column… Read More »Custom column in Power BI
Home » POWER BI » Power Query Editor »
Power Query Editor
The Power Query Editor in Power BI is used to transform or edit data files before they are actually loaded into the Power BI
How to show last refresh date in Power BI
Showing a last refresh date and time in Power BI report let you know how fresh your report data is as sometimes report viewer can… Read More »How to show last refresh date in Power BI
Refresh error from changing column names in data source
You might have faced a refresh error when a column name gets changed in data source, it happens when column name gets changed in data… Read More »Refresh error from changing column names in data source
Add a columns from examples in Power BI
Power Query add column from examples feature, allows you to add new columns to data model simply by providing one or more example values for… Read More »Add a columns from examples in Power BI
Append Queries in Power BI
The append operation in Power Query creates a single table by adding the contents of one or more tables to another, and aggregates the column… Read More »Append Queries in Power BI
Unpivot Columns in Power BI
Power Query provides a feature that is Unpivot columns which allows you to transform columns into attribute-value pairs, where columns become rows. Columns that you… Read More »Unpivot Columns in Power BI
Fill values in column in Power BI
Power Query provides a FILL operation which allows you to fill up and fill down to replace null values with the last non-empty value in… Read More »Fill values in column in Power BI
Profile Data in Power BI
The data profiling allows a intuitive ways to clean, transform, and understand data in Power Query Editor, which helps you identifying the nuances of the… Read More »Profile Data in Power BI
Choose and Remove columns in Power Query
Choose columns and Remove columns are operations that allows you to define what columns you need to keep in your table and which ones it needs… Read More »Choose and Remove columns in Power Query
Split columns by positions
Power Query allows you to split a column with various options, one of them is split columns by positions which split a text columns at… Read More »Split columns by positions
Pivot Columns in Power BI
Pivot column is a feature available in Power Query which allows you turn rows to columns. Basically, Power Query groups each unique values and performs… Read More »Pivot Columns in Power BI
Import text using examples feature Power BI
Power BI August 2020 update has released a new feature Import text using examples, which allows you to import text/csv file which allows you to… Read More »Import text using examples feature Power BI
Merge in Power BI
Merge Queries in Power BI allows you to join two existing tables together based on matching values from one or multiple columns. Basically, it is… Read More »Merge in Power BI
Create Index column using a Power Query
Create Index column using a Power Query in Power Bi
Using a Power Query, you can add index column to your data that serves as a row counter to rows in data table, it is really a best feature of power query.
- « Previous
- 1
- 2