Power Query
A data connectivity and transformation tool built into Microsoft Excel and Power BI. It allows users to perform data cleansing, format conversion, and query merging through a graphical interface or M language scripts, and is suited for handling complex structured data from APIs, databases, or irregular files.
Timeline (last 90 days)
Power Query is a data connection and transformation tool built into Excel and Power BI, supporting data cleaning and transformation through a graphical interface or the M language.
When processing nested object data, users typically need to perform column expansion operations in Power Query to flatten nested structures into multiple rows.
Multi-value cell support may simplify data cleaning workflows and reduce reliance on Power Query or external scripts.
All Facts (3)
Power Query is a data connection and transformation tool built into Excel and Power BI, supporting data cleaning and transformation through a graphical interface or the M language.
50%UnverifiedWhen processing nested object data, users typically need to perform column expansion operations in Power Query to flatten nested structures into multiple rows.
50%UnverifiedMulti-value cell support may simplify data cleaning workflows and reduce reliance on Power Query or external scripts.
50%