Create a Dataset from Microsoft Power BI Cloud

NOTE: Microsoft Power BI Semantic Models are referred to as Datasets in Metric Insights application.

This article describes how to create a Metric Insights' Dataset from Microsoft Power BI Semantic Model.

PREREQUISITE:

1. Create New Power BI Cloud Dataset

Access New > Dataset > Create New

  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. Define whether the Dataset should be searchable
  4. Category: specify the Category where your Dataset will be placed

2. Define the Settings for Data Collection

Access the Data tab

  1. Specify the Data Storage where the Dataset will be stored
  2. Data Source: select the connection profile you have created for Microsoft Power BI Cloud
  3. Specify the Data collection trigger that will be used to collect data for your Dataset
  4. Report: select a Microsoft Power BI Object that should serve as a basis for your Dataset
  5. Based on your selection in the Report field:
    • If you select a Semantic Model (Dataset), you will be prompted to enter an MDX/DAX query to specify the data you want to retrieve from Power BI.
      • NOTE: If the OleDB Data parameter of Plugin Connection Profile is set to "false", only DAX queries can be used
    • If you select a table within the Semantic Model, you can use the Visual Editor to select columns, which will automatically generate a simple MIQL query.

NOTE: The data from Power BI can be fetched via DAX API without using an RDP. Note that this method of fetching data has limitations of 100,000 rows or 1,000,000 values per request. This setting is controlled by the OleDB data parameter in Microsoft Power BI Cloud plugin connection profile.

  1. Once you are ready with your command, click [Validate]
    • If the statement is valid, the Validation Rows Preview section pops up at the bottom of the screen. You can also open it by clicking Show validation rows under the Plugin command box.
  2. [Enable & View] to proceed to Dataset Viewer

NOTES: 

  1. Entire field names that contain special characters, aggregation and commas must be enclosed in quotes (single or double). 
  2. It is acceptable to enclose all fields and values in quotes.

If you encounter the "Failed to connect to OLE-DB server. Check your Dataset server location and updates for Analyze in Excel" error message, run the RDP service as an AD service account:

  • Access Services > Metric Insights Data Processor Daemon > Properties > Log On, select AD service account

3. See the Dataset Viewer

To view the options available to complete the definition of this new Dataset, see Access, Create, and modify Dataset Views.