Create a Dataset from Microsoft Power BI Report Server
This article describes how to create a Dataset populated with data sourced from Microsoft Power BI Report Server.
For general instructions on building a Dataset, see Create a Dataset from any Data Source.
1. Access New > Dataset > Create New
Alternatively, you can create a Dataset from the Plugin Data Source Editor (access the Data tab > [+ New Dataset]).
- Measured: select the measurement interval that applies to your element
- Collecting: is disabled by default and is enabled once you enable the Dataset
- Category: specify the Category where your Dataset will be placed
- Move to the Data tab
You will be redirected to the Dataset Editor.
2. Define the Settings for Data Collection
- Data Source: select the connection profile you have created for Splunk
- Data collection trigger: specify the Trigger to fetch data for the Dataset
- Microsoft Power BI Report Server Report: select a Microsoft Power BI Object to serve as a basis of your Dataset
- Plugin command: [Select Columns] from the Visual tab, or enter an MIQL plugin command directly from the Command tab
- Validate your query
2.1. Example using Visual Editor
The Microsoft Power BI Report Server Query Builder allows constructing commands without the need to learn the plugin syntax and avoiding typos/mistakes.
- 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.
3. Plugin command will be validated and data collected on Save
- If the command is validated successfully, click [Save]. The Dataset columns and Data Preview are going to be shown below.
- [Enable & View]
4. Check the Dataset in Viewer
- Default View is All data. Any changes made will not affect the All data View, but may be saved as a New View
- For more information on using Filters, refer to Create a Dataset View
- Access Actions > Build Metrics to build Metrics directly from the Dataset Viewer
- For detailed information on creating a Metric, see Create Metrics from a Dataset View