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.

PREREQUISITE:

 Establish connectivity to Microsoft Power BI Report Server.

1. Access New > Dataset > Create New

Alternatively, you can create a Dataset from the Plugin Data Source Editor (access the Data tab > [+ New Dataset]).

  1. Measured: select the measurement interval that applies to your element
  2. Collecting: is disabled by default and is enabled once you enable the Dataset
  3. Category: specify the Category where your Dataset will be placed
  4. Move to the Data tab  

You will be redirected to the Dataset Editor.

2. Define the Settings for Data Collection

[6.3.1] Datasets can be moved between the available Data Storages. The screen below shows Tableau, but the functionality is essentially the same for all Plugins.

Click the Move icon next to the Data Storage on Data tab and follow the prompts to complete the operation.

  1. Data Source: select the connection profile you have created for Splunk
  2. Data collection trigger: specify the Trigger to fetch data for the Dataset
  3. Microsoft Power BI Report Server Report: select a Microsoft Power BI Object to serve as a basis of your Dataset
  4. Plugin command: [Select Columns] from the Visual tab, or enter an MIQL plugin command directly from the Command tab
  5. 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.

  1. Select the Fields for your Dataset
  2. Optionally, add Derived fields and/or Count of duplicate rows
  3. [Save] your settings. Plugin command validation will start automatically.

3. Plugin command will be validated and data collected on Save

  1. If the command is validated successfully, click [Save]. The Dataset columns and Data Preview are going to be shown below.
  2. [Enable & View]

4. Check the Dataset in Viewer

  1. Default View is All data. Any changes made will not affect the All data View, but may be saved as a New View
  2. For more information on using Filters, refer to Create a Dataset View
  3. Access Actions > Build Metrics to build Metrics directly from the Dataset Viewer