microsoft-power-bi

# Microsoft Power BI

Microsoft Power BI is a business intelligence platform for visualizing and sharing data insights. It's used by data analysts, business users, and IT professionals to create reports, dashboards, and data visualizations. These tools help organizations monitor key performance indicators and identify trends.

Official docs: https://learn.microsoft.com/power-bi/

## Microsoft Power BI Overview

- **Dataset**
  - **Column**
- **Report**
- **Dashboard**
- **Dataflow**
- **Workspace**
- **Gateway**

## Working with Microsoft Power BI

This skill uses the Membrane CLI to interact with Microsoft Power BI. Membrane handles authentication and credentials refresh automatically — so you can focus on the integration logic rather than auth plumbing.

### Install the CLI

Install the Membrane CLI so you can run `membrane` from the terminal:

```bash
npm install -g @membranehq/cli
```

### First-time setup

```bash
membrane login --tenant
```

A browser window opens for authentication.

**Headless environments:** Run the command, copy the printed URL for the user to open in a browser, then complete with `membrane login complete <code>`.

### Connecting to Microsoft Power BI

1. **Create a new connection:**
   ```bash
   membrane search microsoft-power-bi --elementType=connector --json
   ```
   Take the connector ID from `output.items[0].element?.id`, then:
   ```bash
   membrane connect --connectorId=CONNECTOR_ID --json
   ```
   The user completes authentication in the browser. The output contains the new connection id.

### Getting list of existing connections
When you are not sure if connection already exists:
1. **Check existing connections:**
   ```bash
   membrane connection list --json
   ```
   If a Microsoft Power BI connection exists, note its `connectionId`


### Searching for actions

When you know what you want to do but not the exact action ID:

```bash
membrane action list --intent=QUERY --connectionId=CONNECTION_ID --json
```
This will return ac...