Change column data type in Power BI
When data is loaded into Power BI model, most of the time Power BI automatically detect the data type of columns. Some times Power BI… Read More »Change column data type in Power BI
Home »
power query editor
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
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
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
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.
