Automatisierte Aktualisierung von Power BI-Datensätzen und historische Überwachung

• •Keine besonderen Voraussetzungen, sofort nach Import nutzbar

{
  "meta": {
    "instanceId": "efb474b59b0341d7791932605bd9ff04a6c7ed9941fdd53dc4a2e4b99a6f9439",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "be660458-e667-4bad-84c6-b43635acb074",
      "name": "Bei Klick auf 'Workflow ausführen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -520,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "34b3425b-e8ce-4713-a786-417b898e3b89",
      "name": "Notizzettel16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1460,
        -1000
      ],
      "parameters": {
        "color": 5,
        "width": 832,
        "height": 1360,
        "content": "## 📬 Need Help or Want to Customize This?\n📧 [robert@ynteractive.com](mailto:robert@ynteractive.com)  \n🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)\n\n\n\n### Step 1: Set Up Azure App Registration\n\n1. Go to [Azure Portal](https://portal.azure.com/)\n2. Navigate to **Azure Active Directory** → **App registrations**\n3. Click **New registration**\n4. Configure your app:\n   - **Name**: `n8n-powerbi-integration`\n   - **Supported account types**: Accounts in this organizational directory only\n   - **Redirect URI**: `https://your-n8n-instance.com/rest/oauth2-credential/callback`\n5. Click **Register**\n6. Note down the **Application (client) ID** and **Directory (tenant) ID**\n\n### Step 2: Configure App Permissions\n\n1. In your app registration, go to **API permissions**\n2. Click **Add a permission** → **Power BI Service**\n3. Select **Delegated permissions** and add:\n   - `Dataset.ReadWrite.All`\n   - `Dataset.Read.All`\n   - `Workspace.Read.All`\n4. Click **Grant admin consent** for your organization\n\n### Step 3: Create Client Secret\n\n1. In your app registration, go to **Certificates & secrets**\n2. Click **New client secret**\n3. Add description: `n8n-powerbi-secret`\n4. Set expiration (recommended: 24 months)\n5. Click **Add** and copy the secret value immediately\n\n### Step 4: Configure Power BI API Credentials in n8n\n\n1. In n8n, go to **Credentials** → **Add Credential** → **Power BI OAuth2 API**\n2. Configure as follows:\n   - **Client ID**: Your Application (client) ID from Step 1\n   - **Client Secret**: Your client secret from Step 3\n   - **Scope**: `https://analysis.windows.net/powerbi/api/.default`\n3. Save and test the connection\n"
      },
      "typeVersion": 1
    },
    {
      "id": "921821cb-ca64-49c9-87d6-083395532c72",
      "name": "Datenquelle aktualisieren",
      "type": "n8n-nodes-powerbi.powerBi",
      "position": [
        -180,
        -360
      ],
      "parameters": {
        "groupId": "me",
        "resource": "dataset",
        "datasetId": "475347ba-f8d9-4f9d-b5c7-87fa6d5afd4c",
        "operation": "refresh"
      },
      "credentials": {
        "powerBiApiOAuth2Api": {
          "id": "fEMWdLtLYSmHmvlb",
          "name": "Power BI account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "53dccada-90a0-4408-aaab-395366109010",
      "name": "Aktualisierungsverlauf prüfen",
      "type": "n8n-nodes-powerbi.powerBi",
      "position": [
        -180,
        -20
      ],
      "parameters": {
        "top": 10,
        "groupId": "me",
        "resource": "dataset",
        "datasetId": "475347ba-f8d9-4f9d-b5c7-87fa6d5afd4c",
        "operation": "getRefreshHistory"
      },
      "credentials": {
        "powerBiApiOAuth2Api": {
          "id": "fEMWdLtLYSmHmvlb",
          "name": "Power BI account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "79ad7fb7-eadb-491d-80bc-6626facd7d3d",
      "name": "Notizzettel",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -600,
        -1000
      ],
      "parameters": {
        "color": 4,
        "width": 712,
        "height": 1360,
        "content": "\n#### Node Configuration Details:\n\n##### When clicking 'Execute workflow' (Manual Trigger)\n- **Type**: Manual Trigger\n- **Purpose**: Allows manual execution of the workflow\n- No configuration needed\n\n##### Refresh Datasource (Power BI)\n- **Resource**: `dataset`\n- **Operation**: `refresh`\n- **Group ID**: `me` (for personal workspace) or your workspace ID\n- **Dataset ID**: Your Power BI dataset ID (from Step 5)\n- **Credentials**: Select your \"Power BI account\"\n\n##### Check Refresh History (Power BI)\n- **Resource**: `dataset`\n- **Operation**: `getRefreshHistory`\n- **Group ID**: `me` (for personal workspace) or your workspace ID  \n- **Dataset ID**: Your Power BI dataset ID (same as above)\n- **Top**: `10` (number of recent refresh records to retrieve)\n- **Credentials**: Select your \"Power BI account\"\n\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "be660458-e667-4bad-84c6-b43635acb074": {
      "main": [
        [
          {
            "node": "921821cb-ca64-49c9-87d6-083395532c72",
            "type": "main",
            "index": 0
          },
          {
            "node": "53dccada-90a0-4408-aaab-395366109010",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}