The downloadable program that accompanies the Microsoft Power BI service, Power BI Desktop, allows you to establish parameters that may be used in a variety of ways when dealing with datasets.
The parameters are simple to generate and may be used during the migration activity or subsequently to enhance or add dynamic components to a dataset. You can, for example, establish parameters that offer network data to raw data or predetermined values for data filtering.
How can you create them?
Because parameters are not reliant on any information, you can construct them before or after you have created your datasets. However, you must create them and specify their starting values.
Select Text from the Category drop-down list and List of values from the Recommended Values drop-down List. When you choose a list of values, a grid opens where you may put in the particular values you wish to give to the parameter, as illustrated in the image below. Make certain that, at minimum, one of the values corresponds to a real SQL Server instance.
After typing the List of values, pick a null value from the Custom Value drop-down list, and then pick the variable’s present value from the Recent Value drop-down list.
To exit the Parameters dialogue box, click OK. The parameter is added to the Queries window by Query Editor, with the present value given in parentheses.
Connecting to a Data Source with Parameters
You’re capable of connecting to the Database Server and getting information from the target dataset now that you’ve established your parameters. Apply your modifications and dismiss the window if you haven’t already.
You may simply modify the settings of the connection attributes by declaring parameters for them if you need to get information from a remote SQL Server instance or dataset.
You may also reuse the same parameters across numerous datasets, sparing you the time and effort of repeating connection information every time you build a dataset depending on the same data source.
Scenario of Access
Content may be seen on the Power BI Server web app, in a Microsoft app like Microsoft Project or SharePoint, or a bespoke application you design.
Externally or internally, users may need access to your Power BI material. You can have both at times.
You’ll be given the option of using Power BI Pro or Power BI Free. In addition to watching privileges, Pro grants you publication rights.
Lines of Products
Power BI partners Integrated is generally used to embed in bespoke apps with only external users and does not require Azure Active Directory authentication.
What’s the deal with Azure B2B?
External users may be efficiently brought into the company (Microsoft Azure tenant) as visitor users using Azure B2B. This offers a “User owns data” situation for external users.
Summary of Quick Decisions
Here’s a brief description that may help in most instances if you examine basic scenarios before diving too far into your personal specifics. However, your specific requirements may influence the ultimate decision-making process.