Skip to main content

Microsoft Power BI

The Microsoft Power BI connector enables easy and secure data synchronization between your application and your customers’ Microsoft Power BI accounts through unified data models.

Authorization

The Microsoft Power BI connector uses OAuth for secure authentication. When creating a connection, the required OAuth scopes are automatically configured based on your specific operations needs (e.g. genericContact::create, genericUser::list).

✓ Automatic token refresh handling
✓ Proactive insufficient permissions detection

View our step-by-step integration guideWhitelabel
Supported
You can choose to provide your own set of clientId and clientSecret for this connector from the Morph Cloud dashboard; allowing a fully whitelabled experience for your end-customers.
import { Morph } from "@runmorph/cloud";

const morph = Morph({ publicKey: "pk_demo_xxxxxxxxxxxxxxx", secretKey: "sk_demo_xxxxxxxxxxxxxxx"}); 

// create a new connection
const connection = morph.connections({ connectorId: "microsoft-power-bi", ownerId: "demo" });
await connection.create({ operations:[ "genericContact::list" ]});

// auhtorize the connection
const { auhtorizationUrl } = await connection.authorize();

// redirect the user to the auhtorizationUrl

Live Demo
Select a connector below to experience our seamless authentication flow and see how easy it is to connect third-party services.

Models

Generic

The Microsoft Power BI connector seamlessly integrates with our unified genericUser model, enabling you to manage Users with rich data including firstName, lastName, email and other key details

API Reference
GET/resources/genericUserList and Search Microsoft Power BI Users
GET/resources/genericUser/:idRetrieve a Microsoft Power BI User
POST/resources/genericUserCreate a Microsoft Power BI User
PATCH/resources/genericUser/:idUpdate a Microsoft Power BI User
DEL/resources/genericUser/:idDelete a Microsoft Power BI User
Custom Fields
Supported
The Microsoft Power BI connector supports our Field Mapping feature, enabling you or your customers to seamlessly map Microsoft Power BI User custom fields to the unified user model. This allows for flexible data synchronization while maintaining data consistency across all connectors.

view User model details

The Microsoft Power BI connector seamlessly integrates with our unified genericWorkspace model, enabling you to manage Workspaces with rich data including name and other key details

API Reference
GET/resources/genericWorkspaceList and Search Microsoft Power BI Workspaces
GET/resources/genericWorkspace/:idRetrieve a Microsoft Power BI Workspace
POST/resources/genericWorkspaceCreate a Microsoft Power BI Workspace
PATCH/resources/genericWorkspace/:idUpdate a Microsoft Power BI Workspace
DEL/resources/genericWorkspace/:idDelete a Microsoft Power BI Workspace
Custom Fields
Supported
The Microsoft Power BI connector supports our Field Mapping feature, enabling you or your customers to seamlessly map Microsoft Power BI Workspace custom fields to the unified workspace model. This allows for flexible data synchronization while maintaining data consistency across all connectors.

view Workspace model details

Custom

Supported
Can’t find the unified model you need? The Microsoft Power BI connector supports your own custom model.

Webhooks

The Microsoft Power BI connector supports real-time event subscriptions, allowing you to receive instant notifications when records are created, updated, or deleted. Below are the supported models and their corresponding triggers.
ModelsCreatedUpdatedDeletedAPI Reference
genericUserview event
genericWorkspaceview event

Proxy

Supported
The Microsoft Power BI connector supports our Proxy Request feature, allowing you to directly call any endpoints from Microsoft Power BI’s public API without needing to handle authentication. Your customer’s token will be automatically set and refreshed as needed, enabling quick implementation of custom connector behaviors. View API Reference.