npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2026 – Pkg Stats / Ryan Hefner

n8n-nodes-microsoftpowerbi

v1.0.0

Published

Node N8N to interact with Microsoft Power BI

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 start

If you're using Docker: Add to your docker-compose.yml file:

environment:
  - N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=true

If you're using the desktop app: Create a .env file in the n8n directory:

N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=true

If you want to set it permanently on Mac/Linux: Add to your ~/.zshrc or ~/.bash_profile:

export N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=true

Compatibility

  • Tested with: 1.116.2 (Success)

Resources