Forum Discussion
Integration: Cube Cloud - Entra ID - Power BI
IMHO, writing a custom Power Query SDK script is likely the best option if you need to pass a JWT token obtained via Microsoft Entra ID to the SQL API of Cube Cloud.
The custom script allows you to implement a specific authentication flow, such as adding JWT tokens to the HTTP headers of the requests sent to the SQL API. This level of control is generally not available with out-of-the-box Power BI connectors.
The script can handle token generation, renewal, and inclusion in requests, which may be necessary depending on how SQL API expects tokens to be handled.
In the other hand, I don't think there is any out-of-the-box Power BI connectors that natively support passing JWT tokens obtained via Microsoft Entra ID directly to a SQL API like the one used by Cube Cloud.
Most Power BI connectors, such as those for SQL Server or PostgreSQL, are designed to handle more traditional authentication methods (username/password, OAuth 2.0 for specific services) and may not natively support JWT-based authentication in the manner required.
IMHO, writing a custom Power Query SDK script is likely the best option if you need to pass a JWT token obtained via Microsoft Entra ID to the SQL API of Cube Cloud.
The custom script allows you to implement a specific authentication flow, such as adding JWT tokens to the HTTP headers of the requests sent to the SQL API. This level of control is generally not available with out-of-the-box Power BI connectors.
The script can handle token generation, renewal, and inclusion in requests, which may be necessary depending on how SQL API expects tokens to be handled.
In the other hand, I don't think there is any out-of-the-box Power BI connectors that natively support passing JWT tokens obtained via Microsoft Entra ID directly to a SQL API like the one used by Cube Cloud.
Most Power BI connectors, such as those for SQL Server or PostgreSQL, are designed to handle more traditional authentication methods (username/password, OAuth 2.0 for specific services) and may not natively support JWT-based authentication in the manner required.