n8n-nodes-microsoftpowerbi
v1.0.0
Published
Node N8N to interact with Microsoft Power BI
Maintainers
Readme
n8n-nodes-microsoftpowerbi
This is an n8n community node. It lets you interact with Microsoft Power BI in your n8n workflows.
Microsoft Power BI is a business intelligence and data analytics platform that enables organizations to connect, visualize, and share insights from their data through interactive dashboards, real-time reporting, and advanced analytics.
n8n is a fair-code licensed workflow automation platform.
Installation
Credentials
Operations
Using as a Tool
Compatibility
Resources
Installation
Follow the installation guide in the n8n community nodes documentation.
Alternatively, you can manually install it:
git clone https://github.com/elevate-agency-data/n8n-nodes-microsoftpowerbi.git
cd n8n-nodes-microsoftpowerbi
npm install Then, place the node file in the ~/.n8n/custom-nodes directory (or follow instructions specific to your n8n installation).
Credentials
To use this node, you need an Microsoft Power BI API key with access to Microsoft Power BI.
Operations
This node supports the following operations within Microsoft Power BI:
- Admin
- Adds power bi encryption key
- Adds user as admin in group
- Assigns workspaces to capacity
- Deletes profile as admin
- Deletes user as admin in group
- Deletes user as admin in pipeline
- Exports dataflow as admin
- Gets activity events
- Gets app users as admin
- Gets apps as admin
- Gets capacities as admin
- Gets capacity users as admin
- Gets dashboard subscriptions as admin
- Gets dashboard users as admin
- Gets dashboards as admin
- Gets dashboards in group as admin
- Gets dataflow datasources as admin
- Gets dataflow users as admin
- Gets dataflows as admin
- Gets dataflows in group as admin
- Gets dataset to dataflows links in group as admin
- Gets dataset users as admin
- Gets datasets as admin
- Gets datasets in group as admin
- Gets datasources as admin
- Gets group as admin
- Gets group users as admin
- Gets groups as admin
- Gets imports as admin
- Gets links shared to whole organization
- Gets modified workspaces
- Gets pipeline users as admin
- Gets pipelines as admin
- Gets power BI encryption keys
- Gets profiles as admin
- Gets published to web
- Gets refreshable for capacity
- Gets refreshables
- Gets refreshables for capacity
- Gets report subscriptions as admin
- Gets report users as admin
- Gets reports as admin
- Gets reports in group as admin
- Gets scan result
- Gets scan status
- Gets tiles as admin
- Gets unused artifacts as admin
- Gets upstream dataflows in group as admin
- Gets user artifact access as admin
- Gets user subscriptions as admin
- Gets workspace info
- Removes labels as admin
- Restores deleted group as admin
- Rotates power BI encryption key
- Sets labels as admin
- Unassigns workspaces from capacity
- Updates capacity as admin
- Updates group as admin
- Updates user as admin in pipeline
- App
- Gets app
- Gets apps
- Gets dahsboards
- Gets dashboard
- Gets report
- Gets reports
- Gets tile
- Gets tiles
- Available Feature
- Gets available feature by name
- Gets available features
- Capacity
- Assigns my workspace to capacity
- Assigns workspace to capacity
- Changes workload state
- Gets capacities
- Gets capacity assignment status
- Gets my workspace capacity assignment status
- Gets refreshable for capacity
- Gets refreshables
- Gets refreshables for capacity
- Returns workload
- Returns workloads
- Dashboard
- Adds dashboard
- Adds dashboard in group
- Clones tile
- Clones tile in group
- Deletes dashboard
- Deletes dashboard in group
- Gets dashboard
- Gets dashboard in group
- Gets dashboards
- Gets dashboards in group
- Gets tile
- Gets tile in group
- Gets tiles
- Gets tiles in group
- Dataflow
- Cancels dataflow transaction
- Deletes dataflow
- Gets dataflow
- Gets dataflow data sources
- Gets dataflow transactions
- Gets dataflows
- Gets upstream dataflows in group
- Refreshes dataflow
- Updates dataflow
- Updates refresh schedule
- Dataflow Storage Account
- Assigns workspace to dataflow storage
- Gets dataflow storage accounts
- Dataset
- Binds to gateway
- Binds to gateway in group
- Cancels refresh
- Cancels refresh in group
- Deletes dataset
- Deletes dataset in group
- Discovers gateways
- Discovers gateways in group
- Executes queries
- Executes queries in group
- Gets dataset
- Gets dataset in group
- Gets dataset to dataflows links in group
- Gets dataset users
- Gets dataset users in group
- Gets datasets
- Gets datasets in group
- Gets datasources
- Gets datasources in group
- Gets direct query refresh schedule
- Gets direct query refresh schedule in group
- Gets gateway datasources
- Gets gateway datasources in group
- Gets parameters
- Gets parameters in group
- Gets query scale out sync status
- Gets query scale out sync status in group
- Gets refresh execution details
- Gets refresh execution details in group
- Gets refresh history
- Gets refresh history in group
- Gets refresh schedule
- Gets refresh schedule in group
- Grants dataset user permissions
- Grants dataset user permissions in group
- Refreshes dataset
- Refreshes dataset in group
- Sets all dataset connections
- Sets all dataset connections in group
- Takes over in group
- Triggers query scale out sync
- Triggers query scale out sync in group
- Updates dataset
- Updates dataset in group
- Updates dataset user permissions
- Updates dataset user permissions in group
- Updates datasources
- Updates datasources in group
- Updates direct query refresh schedule
- Updates direct query refresh schedule in group
- Updates parameters
- Updates parameters in group
- Updates refresh schedule
- Updates refresh schedule in group
- Embed Token
- Generates token for dashboards in group
- Generates token
- Generates token for datasets in group
- Generates token for report creation in group
- Generates token for reports in group
- Generates token for tiles in group
- Gateway
- Adds datasource user
- Creates datasource
- Deletes datasource
- Deletes datasource user
- Gets datasource
- Gets datasource status
- Gets datasource users
- Gets datasources
- Gets gateway
- Gets gateways
- Updates datasource
- Goal
- Adds goal
- Deletes goal by ID
- Deletes goal current value connection
- Deletes goal target value connection
- Gets goal by ID
- Gets goals
- Gets refresh history
- Refreshes goal current value
- Refreshes goal target value
- Updates goal by ID
- Goal Note
- Adds goal note
- Deletes goal note by ID
- Updates goal note by ID
- Goal Value
- Creates goal value
- Deletes goal value by ID
- Gets goal values
- Gets goal value by ID
- Updates goal value by ID
- Goals Status Rule
- Creates or updates rules
- Deletes rule
- Gets rules
- Group
- Adds group user
- Creates group
- Deletes group
- Deletes user in group
- Gets group
- Gets group users
- Gets groups
- Updates group
- Updates group user
- Import
- Creates import
- Creates import in group
- Creates temporary upload location
- Creates temporary upload location in group
- Gets import
- Gets import in group
- Gets imports
- Gets imports in group
- Pipeline
- Assigns workspace
- Creates pipeline
- Deletes pipeline
- Deletes pipeline user
- Deploys all
- Deploys specified item
- Gets pipeline
- Gets pipeline operation
- Gets pipeline stage artifacts
- Gets pipeline stages
- Gets pipeline operations
- Gets pipeline users
- Gets pipelines
- Unassigns workspace
- Updates pipeline
- Updates pipeline user
- Profil
- Creates profile
- Deletes profile
- Gets profile
- Lists profiles
- Updates profile
- Push Dataset
- Adds rows
- Adds rows in group
- Creates dataset
- Creates dataset in group
- Deletes rows
- Deletes rows in group
- Gets tables
- Gets tables in group
- Updates table
- Updates table in group
- Report
- Binds to gateway
- Binds to gateway in group
- Clones report
- Clones report in group
- Deletes report
- Deletes report in group
- Exports report
- Exports report in group
- Exports to file
- Exports to file in group
- Gets datasources
- Gets datasources in group
- Gets export to file status
- Gets export to file status in group
- Gets file of export to file
- Gets file of export to file in group
- Gets page
- Gets page in group
- Gets pages
- Gets pages in group
- Gets report
- Gets report in group
- Gets reports
- Gets reports in group
- Rebinds report
- Rebinds report in group
- Takes over in group
- Updates datasources
- Updates datasources in group
- Updates report content
- Updates report content in group
- Scorecard
- Creates scorecard
- Deletes scorecard by ID
- Gets scorecard by ID
- Gets scorecard by report ID
- Lists scorecards
- Moves goals
- Updates scorecard by ID
- Template App
- Creates an install ticket
- User
- Refreshes user permissions
Retrieve information from the Microsoft Power BI API.
Using as a Tool
This node can be used as a tool in n8n AI Agents. To enable community nodes as tools, you need to set the N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE environment variable to true.
Setting the Environment Variable
If you're using a bash/zsh shell:
export N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=true
n8n startIf you're using Docker: Add to your docker-compose.yml file:
environment:
- N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=trueIf you're using the desktop app:
Create a .env file in the n8n directory:
N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=trueIf you want to set it permanently on Mac/Linux:
Add to your ~/.zshrc or ~/.bash_profile:
export N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=trueCompatibility
- Tested with: 1.116.2 (Success)
