Monitor Azure subscription resources with cost and usage tracking and reports
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs manually, when you click “Execute workflow”. It uses only n8n's built-in nodes. It also calls api.powerbi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Configuration (Edit Fields (Set)): sets 5 fields: subscriptionId, tenantId, billingPeriod…
- Query Azure Resources (HTTP Request): calls an HTTP API
- Get Cost Data (HTTP Request): calls an HTTP API
- Merge and Process Data (Code): runs custom JavaScript code
- Format Report (Code): runs custom JavaScript code
- Check If Data Exists (If): checks a condition and branches into true / false
- Output Report (Edit Fields (Set)): sets 4 fields: report, htmlReport, totalCost…
- No Data Found (Edit Fields (Set)): sets 1 field: error
- Export to Excel (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Prepare Power BI Data (Edit Fields (Set)): sets 4 fields: summary, resources, timestamp…
…plus 2 more steps. See the full node list below.
HTTP calls to: api.powerbi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Spreadsheet File (Export to Excel): Convert to File / Extract from File.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Monitor Azure subscription resources with cost and usage tracking Template Name Monitor Azure subscription resources with cost and usage tracking Description Automatically connect to your Azure subscription to retrieve all resources and track costs. Generates…