Create a Dataset sourced from Power BI
This introductory article describes how to define the basic settings for a Dataset that is sourced from Microsoft Power BI.
- Data Source: Metric Insights must have a working data source connection to Power BI. If you have not yet configured a data source connection, see Establish Connectivity to Microsoft Power BI.
1. Access New > Datasets > Create New
The Dataset Editor opens for input.
2. Dataset Editor > Info tab
- Measured: select the measurement interval that applies to the level of aggregation that you want in your result set
- Collecting: new Datasets are always disabled by default to make sure that you can take time to configure them properly before enabling. This setting is duplicated at the top of the screen
- Name: provide a unique name for your Dataset. Preferably, the Dataset name should explain what kind of data it contains
- Description: optionally, provide any additional information about your Dataset
- Category: specify the Category where you Dataset will be placed
Move to the Data tab to define the source of data and how often it should be updated.
3. Define the Settings for Data Collection
- Data Source: select the connection profile you have created for Microsoft Power BI
- Data collection trigger: specify the Trigger that will be used to collect data for your Dataset
Report: select a Microsoft Power BI Object that should serve as a basis of your Dataset
- Types of Microsoft Power BI Objects whose data can be queried by the Metric Insights plugin are described in Power BI Plugin Capabilities
- Input an MIQL Plugin Command listing all the data you would like to fetch from Power BI.
- Alternatively, use the Visual Editor
- Once you are ready with your command, click Validate
- Entire field names that contain special characters, aggregation and commas must be enclosed in quotes (single or double).
- It is acceptable to enclose all fields and values in quotes.
[…] + Notation is used to signify that the MIQL parts of a statement are optional/can be repeated.
3.1. Example using the Visual Editor
The Microsoft Power BI Query Builder allows constructing commands without the need to learn the plugin syntax.
- Select the fields for your Dataset
- Optionally, add Derived fields and/or Count of duplicate rows
Save your settings. Plugin command validation will start automatically.
4. Plugin command will be validated and data collected on Save
- If the command is validated successfully, the Dataset columns and Data Preview are going to be shown below.
- At the upper right corner of the screen click Enable & View.