32 Query Create and manage Access parameters from Query Editor (Edit Queries on Home tab) or from Home tab Apr-2016 Parameters parameters in directly. Query Editor to make the PBI file dynamic Apply parameters to filter definitions From Query Editor: for different columns Edit Parameters only allows you to edit the values of the parameters, not their definition. 33 Power BI PBIT files ony Apr-2016 Template files contain the queries, visuals, formatting, model metadata, Main Menu Export Power BI Template – – etc…not the data Can be used with parameters like an SSRS report user – accesses a template 34 Conditional GUI interface for Apr-2016 Columns creating conditional expressions and rules Can eliminate need for custom M expression
32 Query Parameters Create and manage parameters in Query Editor to make the PBI file dynamic Apply parameters to filter definitions for different columns Edit Parameters only allows you to edit the values of the parameters, not their definition. Access parameters from Query Editor (Edit Queries on Home tab) or from Home tab directly. From Query Editor: Apr-2016 33 Power BI Template files PBIT files ony contain the queries, visuals, formatting, model metadata, etc…not the data Can be used with parameters like an SSRS report – user accesses a template Main Menu – Export – Power BI Template Apr-2016 34 Conditional Columns GUI interface for creating conditional expressions and rules Can eliminate need for custom M expression Apr-2016
pbi-desktop-data-transformation-features.docx