Power BI Plugin Capabilities

This article describes the current capabilities of the Metric Insights Power BI Plugin.    

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.

Beginning in v7.1.0, the DATASET Object is renamed to SEMANTIC_MODEL.

Power BI Objects Collect Image Get Data Embed in a Portal Page Notes
App - - -
  • Due to PBI API limitations, Apps cannot be embedded in the viewer and must be set to open in a new browser tab
  • Service Principal auth does not support retrieving Apps
Workspace - - -
Semantic Model - + -
Report + - +
Dashboard + - +
Dashboard Tile
(pinned Report chart or table)		 + - +

Image can be collected for the entire Dashboard only, not specific Tiles
Dashboard Live Page
(pinned Report chart or table)		 + - + Image can be collected for the entire Dashboard, but not for a specific Live Page

Get Objects

Microsoft Power BI Cloud Plugin supports pulling the following object types:

  • DASHBOARD
  • TILE
  • SEMANTIC_MODEL
  • TABLE
  • REPORT
  • APP
  • WORKSPACE

The scope of the collected objects can be controlled by the Object types to collect Optional Parameter.

Get Data

By getting data in Metric Insights we mean the ability to create Datasets. Microsoft Power BI Cloud Plugin supports creating Datasets from Microsoft Power BI Semantic Models.

Get Filters

The Plugin supports pulling Filters from Power BI Reports to Metric Insights. Filters and Values can be added individually. Users can then apply Filters to External Reports and customize their display depending on input.

Get Report Image

The Plugin supports getting images for the following types of objects:

  • DASHBOARD
  • REPORT

Embed in iFrame

Power BI External Report can be embedded into the application (Show "In iFrame") or other HTML pages by using embed codes.

Support OAuth 2.0

Microsoft Power BI Cloud Plugin supports OAuth 2.0.

Support Content Autosync

Power BI content can be synchronized with Metric Insights to automatically create new External Reports from Power BI objects and simplify the process of updating existing External Reports.

Capture Metadata

The plugin captures metadata for the following object types:

  • REPORT: (created, last_modified, created_by, last_modified_by)
  • SEMANTIC_MODEL: (created)
  • APP: (last_modified)

For more information on embedding Power BI Objects in Portal Pages, see Embedding Overview.

Microsoft Power BI Objects

1. Semantic Models

  • Semantic models are collections of data in Microsoft Power BI.
  • Data from Power BI Semantic Models can be fetched to Metric Insights.

2. Reports

  • Reports are one or more pages of visualizations (line chars, maps, etc).
  • Images can be collected from Power BI Reports via the respective plugin connection profile.

Report Visualizations can be pinned to Dashboards as Tiles.

3. Dashboards

  • Dashboards can contain Tiles and Live Pages.
  • Metric Insights allows you to collect Image for the entire Dashboard.

3.1. Tiles

  • A Tile is a Report visualization element that can be pinned to a Dashboard.
  • You can get Images for Tiles.

3.2. Live Pages

  • An entire Report can be pinned to a Dashboard as a Live Page.
  • Pinning Live Page enables changes to reports to appear in the dashboard tile when the page is refreshed.
  • Only images from Live Pages can be fetched by the Metric Insights plugin.