Power Query is the front door of your analytics stack: connect to databases, folders, APIs, and SharePoint. Apply filter rows, change types, merge queries, and group by—all recorded as reusable steps.
Prefer query folding to SQL sources when possible for better performance at scale.