Power BI

Overview

This node interacts with the Power BI API to retrieve various types of data related to Power BI resources. Specifically, for the Gateway resource and the Get Datasource Status operation, it fetches the current status of a specified datasource within a given gateway. This is useful for monitoring and managing data connectivity in Power BI environments.

Typical use cases include:

• Checking if a datasource connected through a gateway is online or experiencing issues.
• Automating monitoring workflows that alert users when datasources become unavailable.
• Integrating datasource status checks into broader reporting or operational dashboards.

Properties

Output

The node outputs JSON data representing the status information of the requested datasource. This typically includes fields such as connection status, last refresh time, error messages (if any), and other metadata relevant to the datasource's health and connectivity.

If the datasource status includes binary data (e.g., logs or diagnostic files), the node would output this in a binary format, but based on the provided code and operation, the output is primarily JSON structured data describing the datasource status.

Dependencies

• Requires access to the Power BI API.
• Needs appropriate authentication credentials configured in n8n, either via OAuth2 or a Bearer Token.
• The node uses internal helper methods to load options dynamically (e.g., gateways and datasources), which depend on successful API communication.
• No additional external dependencies beyond the Power BI API and n8n environment are required.

Troubleshooting

• Common Issues:

  • Invalid or expired authentication tokens can cause authorization errors.
  • Specifying an incorrect gateway or datasource ID/name may result in "not found" errors.
  • Network connectivity issues can prevent API calls from succeeding.

• Error Messages:

  • "The resource \"gateway\" is not supported!" — indicates an unsupported resource was selected; ensure the resource and operation combination is valid.
  • API errors returned from Power BI (e.g., 401 Unauthorized, 404 Not Found) will be surfaced; verify credentials and input parameters.

• Resolutions:

  • Refresh or reconfigure authentication credentials.
  • Double-check gateway and datasource identifiers.
  • Ensure network access to Power BI services.
  • Use the node’s "Continue On Fail" option to handle errors gracefully in workflows.

Links and References

• Power BI REST API Documentation
• n8n Expressions Documentation
• Power BI Gateways Overview