Power Query in Power BI allows us to clean, transform and prepare the data from an existing data sources.
Getting Started With Power Query
Refresh error due to column name change in data source
Group By the data using Power Query
Create Index column using Power Query
Import text using examples feature Power BI
Pivot columns – turn rows into columns
Choose and Remove Columns from table
Data Profiling: Column Quality, Column Distribution & Column Profile
Fill values operation: fill down and fill up
Show last refresh date & time in report
AI Insights in Power BI (Text Analytics, Vision, Azure Machine Learning)
Using IN operator in Power Query M code
Remove duplicate and keep latest record in table using Power Query
Replace multiple columns values in Power Query
Replace multiple values in one column Power Query
Difference between two dates in Power Query
Remove occurrence of matching rows from table
Adding Prefix and Suffix to values in column
Handle NULL values in Power Query
Add comments to Power Query steps
Create and invoke custom function
Create Custom Function to get two dates difference
Insert text into an existing text in Power Query
Extract first and last characters from string in Power Query
Remove characters from string in Power Query
Remove a specified number of characters from a text, starting at a specified position
Power Query Remove Duplicates but Keep Latest Record
Also Read..
