Forum Discussion
Integration: Cube Cloud - Entra ID - Power BI
Hi All,
My first post here, happy to be here :)!
I'm having the following problem statement:
I want to control authentication & authorization to cube cloud from Power BI using Microsoft entra ID as identity provider.
Solution statement:
*Cube cloud runs on a PostgreSQL Database
Is writing a custom power query SDK script the best option to pass obtained credentials from Power BI to the SQL API of cube cloud ?
Or are there any out of the box Power BI connectors that automatically pass obtained credentials(JWT token) to SQL API.
here are the docs for SQL API from Cube Cloud:
SQL API | Cube Docs
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.
1 Reply
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.