Power BI Header Auth

Overview

This node allows executing DAX queries on Power BI datasets using header-based authentication with a bearer token. It is useful for users who want to programmatically query their Power BI datasets to retrieve data or insights without manually accessing the Power BI service.

Common scenarios include:

• Automating data retrieval from Power BI datasets for reporting or integration with other systems.
• Running custom DAX queries to extract specific slices of data.
• Integrating Power BI dataset querying into workflows that require dynamic data fetching.

For example, you can use this node to run a DAX query like EVALUATE VALUES(MyMainTable) to get all distinct values from a table named "MyMainTable" in a specified dataset.

Properties

Output

The node outputs JSON data representing the result of the executed DAX query on the Power BI dataset. The structure depends on the query but typically includes rows and columns returned by the query.

If the query returns tabular data, the output JSON will contain an array of objects where each object corresponds to a row with key-value pairs representing column names and their values.

The node does not output binary data.

Dependencies

• Requires a valid bearer token for Power BI API authentication. This token must be provided either as input data or via the node parameter.
• Access to the Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
• The user must have appropriate permissions to access the specified workspace (group) and dataset.
• No additional external dependencies beyond the Power BI API and proper authentication.

Troubleshooting

• Missing or invalid token: If no token is provided or the token is invalid, the node will throw an error indicating that the authentication token is required or failed to authenticate. Ensure the token is current and correctly formatted (without the "Bearer" prefix).
• Invalid dataset or group ID: Selecting a non-existent or unauthorized workspace or dataset will cause API errors. Verify IDs are correct and accessible.
• Malformed DAX query: Errors in the DAX query syntax will result in API errors. Test queries in Power BI Desktop or the Power BI service before using them here.
• API rate limits or connectivity issues: Network problems or hitting API limits may cause failures. Retry or check network connectivity.
• Error messages generally come from the Power BI API and will be included in the node output if continueOnFail is enabled.

Links and References

• Power BI REST API Documentation
• DAX Reference
• Power BI Developer Resources

This summary is based solely on static analysis of the provided source code and property definitions.