• Understand parameter-driven data ingestion in Power BI.
• Create and manage Power Query parameters.
• Use parameters to control query transformations.
• Apply parameters to data ingestion processes.
• Build more flexible data connections.
• Use parameters with Power Query functions.
• Understand dynamic M query parameters.
• Configure parameter settings in Power BI Service.

Module 1: Introduction to Parameter-Driven Data Ingestion

Module 2: Power Query Parameters

Module 3: Using Parameters in Queries

Module 4: Parameters and Custom Functions

Module 5: Dynamic Data Ingestion

Module 6: Dynamic M Query Parameters

Module 7: Power BI Service Parameter Management

Module 8: Parameter-Driven Data Ingestion Project

1 Day

Course Completion Certificate by Network Binary

• Create a Power Query parameter.
• Configure parameter name, type and current value.
• Use a parameter as a query transformation argument.
• Filter data using a parameter.
• Create a custom Power Query function.
• Pass parameters to a custom function.
• Build a parameterized M query.
• Create dynamic M query parameters.
• Bind a model field to a parameter.
• Use a slicer to control a dynamic parameter.
• Configure multi-value parameter behavior.
• Publish a parameterized semantic model.
• Review and modify parameter settings in Power BI Service.

• Power BI users
• Data Analysts
• Business Intelligence professionals
• Power BI developers
• Data professionals working with Power Query
• Professionals who need flexible data-loading processes

• Basic familiarity with Microsoft Power BI.
• Basic understanding of Power Query.
• Basic understanding of data sources and data transformations.