Microsoft Power BI v2
Provides integration with Microsoft Power BI, a business intelligence platform for datasets, reports, dashboards and workspaces.
Use the Node to stream records from JSON REST queries or submit a single Power BI REST request.
Revision History
0.0.0.4 - Initial release.
Connection
| Property | Type | Description |
|---|---|---|
Authentication |
Enum | Application access or delegated user access. |
TenantId |
String | Microsoft Entra directory identifier. |
ClientId |
String | Microsoft Entra application identifier. |
ClientSecret |
Masked | Microsoft Entra application secret. |
Scopes |
String | Delegated Power BI permissions; reconnect after changing scopes. |
AccessToken |
Masked | Access token obtained through Connect. |
RefreshToken |
Masked | Refresh token obtained through Connect. |
ProfileId |
String | Optional service principal profile GUID for Power BI Embedded. |
Setup Notes
This Node runs on Cloud Runtimes.
Configure Authentication to ServicePrincipal or DelegatedOAuth. Enter the Microsoft Entra tenant and application credentials. Grant the permissions and workspace access required by the target operation. For delegated access, configure Scopes and connect the account. Set ProfileId only when using a Power BI Embedded service-principal profile.
The Connection test reads the first workspace page; token acquisition alone does not prove API access. Enable the applicable Power BI service-principal tenant settings when using application access. Reconnect delegated OAuth after changing Scopes.
Methods
Query
Streams rows from a Power BI JSON GET endpoint, including continuation pages.
| Parameter | Type | Description |
|---|---|---|
Connection |
Connection | Power BI authentication. |
Path |
String | Path relative to v1.0/myorg, including any endpoint query parameters. |
| Return | Type | Description |
|---|---|---|
Response |
Array | Provider-shaped JSON rows, without Flowgear mutation metadata. |
Request
Sends one Power BI REST request and returns its status, headers and JSON body.
| Parameter | Type | Description |
|---|---|---|
Connection |
Connection | Power BI authentication. |
Method |
Enum | HTTP verb required by the endpoint. |
Path |
String | Path relative to v1.0/myorg, including any endpoint query parameters. |
Body |
Object | JSON request body; null sends no body. |
| Return | Type | Description |
|---|---|---|
Response |
Object | An envelope containing StatusCode, Headers and the original JSON Body. Non-GET requests also include Flowgear.IsSuccess, Flowgear.Message and Flowgear.Request. |
Usage Notes
- Paths are relative to the public-cloud Power BI REST API root. Browser URLs, sovereign clouds and Azure Resource Manager endpoints are unsupported.
- Query follows supported continuation links and workspace offset pagination internally. The first page is read before streaming begins.
- Request returns one response envelope with HTTP status, headers and JSON body; accepted asynchronous operations may still need later status checks.
- Only JSON REST operations are supported. Multipart PBIX uploads and binary exports are outside this Node.