From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Power Query and M language

Power Query and M language - Power BI Tutorial

From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Start my 1-month free trial Buy for my team

Power Query and M language

“

- [Instructor] The Power Query Editor is an important part of the Power BI ecosystem. Power Query can help us take messy data to format and structure it for use in calculations in visuals once we load this data into the Power BI interface. Power Query does not actually alter the data source itself, but rather it creates its own query as a connection. Power Query is also available in Microsoft Excel to set up ETL frameworks. The term ETL stands for Extract, Transform, and Load, and it's an important framework for working not just with Power BI, but data analytics in general. Extracting the data involves connecting to data sources. This includes flat files like Excel, text, or CSV files. It also includes databases like SQL Server, Azure, and AWS to name a few, as well as internet services like Salesforce. Once we extract the data from its data source, we can then use Power Query to transform the data into a useful table…

Contents