Prepare the data — Microsoft Certified: Power BI Data Analyst Associate

The official AZURE documentation our Prepare the data practice questions are cited to. Review the primary sources, then practise.

Official references for this objective

Microsoft — Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

in the Power BI Desktop Model view, select the newly created field, and in the Properties pane, select Advanced .
Microsoft — Power BI usage scenarios: Self-service data preparation (legacy) - Power BI | Microsoft Learn

relocating the data preparation work from Power Query (within individual Power BI Desktop files) to Power Query Online (using a Power BI dataflow ). The
Microsoft — Configuring dataflow storage to use Azure Data Lake Gen 2 (legacy) - Power BI | Microsoft Learn

After the dataflow storage has been configured to use Azure Data Lake Gen 2, there's no way to automatically revert. The process to return to
Microsoft — Create and share cloud data sources in the Power BI service - Power BI | Microsoft Learn

To let users connect their artifacts to the data source, grant at least User permission.
Microsoft — Prepare Data for Display in a Tablix Data Region in a Power BI Paginated Report - Power BI | Microsoft Learn

the following expression substitutes the text Null wherever a null value occurs in the field [Size] . =IIF(Fields!Size.Value IS NOTHING,"Null",Fields!Size.Value)
Microsoft — Use Python in Power BI Power Query Editor - Power BI | Microsoft Learn

You need a Personal Gateway installed on the machine where the file is located, and where Python is installed.