Using parameters
In this section, we will look at the Power BI Desktop query parameters, which provide a kind of way in which we can filter data. There were some developments and updates made to Power BI Desktop in 2016 that improved the ability to create parameters and use them in various ways. The most common ways that we can reference parameters are through data sources, filter rows, keep rows, and remove and replace rows. It is also possible to load the parameters into the data model so that we can reference them from measures, calculated columns, tables, and reports.
Parameterizing a data source
In this section, we will look at how we can connect different data sources that have been defined in query parameters to load different columns or connections to data sources. One of the great things is that certain pieces of software, such as Salesforce objects, SharePoint, and Power BI Desktop, allow you to use parameters when defining your connection properties. This means that...