Reference · built on requestConnectorMarketing, reviews & analytics

Power BI

Workspaces, datasets, refresh status, reports, and dashboards across Power BI Service via the Microsoft Power BI REST API.

Request accessPricing ↗

About

Power BI is Microsoft's business analytics service providing interactive visualizations and business intelligence capabilities. Its REST API allows applications to manage workspace contents, inspect dataset schemas, monitor and trigger data refreshes, push real-time table rows, query reports, and export paginated reports to standard formats.

Through Fibric, an operator monitors dataset refresh health and operational metrics, proposing dataset refreshes or push data inserts for team sign-off.

This is a reference listing. It documents what Fibric would read from Power BI and what it could propose, based on the vendor's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Workspaces and capacity assignments through GET /v1.0/myorg/groups
  • Datasets, tables, and column schemas via GET /v1.0/myorg/groups/{groupId}/datasets
  • Dataset refresh history and failure messages from GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes
  • Reports, report pages, and embed details through GET /v1.0/myorg/groups/{groupId}/reports
  • Dashboards and dashboard tiles via GET /v1.0/myorg/groups/{groupId}/dashboards

Proposed actions

  • Target capability: propose triggering a dataset refresh via POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes
  • Target capability: propose pushing rows into a dataset table via POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/tables/{tableName}/rows
  • Target capability: propose updating parameter values on an existing semantic dataset
  • Target capability: propose requesting an export of a report to PDF or PowerPoint

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Trigger dataset refreshes after ETL completion

    When overnight data warehouse load jobs finish, propose triggering downstream Power BI dataset refreshes so executive dashboards reflect fresh data.

    With Data Freshness, Morning Brief

  • Alert on failed dataset refresh runs

    Monitor refresh history for credential expiration or gateway connection timeouts, proposing diagnostic alerts to analytics engineers before morning reviews.

    With Integration Health, Anomaly Notice

  • Assemble monthly board pack reports

    Schedule recurring exports of standard operating dashboards to PDF, proposing board briefing packs with attached performance summaries.

    With Board Pack

Requirements

  • A Power BI Pro or Power BI Premium workspace license with API access enabled
  • A Microsoft Entra ID app registration or service principal with granted Power BI tenant permissions
  • Admin or Member workspace permissions assigned to the service principal or account
Authentication
OAuth 2.0 access token issued by Microsoft Entra ID with Power BI Service permissions such as Dataset.ReadWrite.All.

Limits

  • Dataset refresh limits restrict scheduled refreshes to 8 per day on Pro and 48 per day on Premium
  • Push dataset endpoints restrict payloads to 10,000 rows per post and 120 requests per minute
  • Export report requests are limited by available Premium or Fabric capacity compute units

Access and pricing

Reference listing. Fibric builds the connector under a managed deployment when you request it. Your quote covers the build, capabilities, usage, and support.

Request Power BI ↗

Questions and answers

Can Fibric authenticate using a Microsoft Entra service principal?
Yes. Power BI supports service principal authentication when enabled in the Power BI tenant admin portal under Developer settings, allowing automated operations without delegated user credentials.
What happens when a dataset refresh fails in Power BI?
The refresh history endpoint returns error codes, failure details, and timestamps. Fibric captures the failure details and can propose notifying the workspace owner.
Does Fibric modify report visualization layouts in Power BI?
No. Fibric manages operational data tasks such as triggering refreshes, pushing rows to streaming datasets, or exporting report files. Report visual designs remain untouched.
Ask about Power BI

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.

This connector listing is developed, published, and supported by Fibric. It describes integration with Power BI through published interfaces. Third-party names and logos identify the systems an integration connects to; they are the property of their respective owners, who are not affiliated with Fibric and do not sponsor or endorse this listing. Trademark policy