search

CreativeDataEU / PowerBITrinoConnector

A Micosoft Power BI Custom Connector allowing you to import Trino data into Power BI.
MIT License
43 stars 16 forks source link

powerBiTrinoConnector with TLS #21

Closed fcollin closed 2 months ago

fcollin commented 3 months ago

Hello,

How do you configure PowerBI to connect to a TLS secured Trino cluster ?

Regards,

pichlerpa commented 3 months ago

Hi @fcollin, you can simply put HTTPS as part of your hostname. Patrick

fcollin commented 3 months ago

Hi,

It does not work. Hostname field can't contain any 'https'. I am trying to connect Trino using the Trino mez connector in Power BI desktop. It works with http on port 8080 but I need to need to test the connector with a secured Trino cluster (TLS + ldap authentication).

Did you manage to do it ?

Regards,

pichlerpa commented 3 months ago

Hi,

You are right, HTTP or HTTPS is automatically added to the host name based on the authentication type used in the Power BI connector. HTTP is used for anonymous (implicit) authentication, while HTTPS is used for all other types, aligning with Trino security standards.

However, the connector has not been used with LDAP, which would be the [Windows] (https://learn.microsoft.com/en-us/power-query/handling-authentication#authentication-kinds) authentication type in Power BI Custom Connectors. Currently, it only supports Basic (UsernamePassword) and Organizational account (OAuth) authentication types.

Regards, Patrick

fcollin commented 3 months ago

Thanks. Basic authentication is fine for LDAP. Did you try to setup a TLS connection between Power BI Desktop and Trino ?

pichlerpa commented 3 months ago

Yes, we configured Trino to support TLS and connected from both Power BI Desktop and Service via HTTPS. Patrick

fcollin commented 3 months ago

Can you describe a little bit more the procedure you made to achieve this please ?

pichlerpa commented 3 months ago

I followed this official Trino instruction and then just used the HTTPS endpoint for connecting.

bvialmcs commented 2 months ago

Hi,

You are right, HTTP or HTTPS is automatically added to the host name based on the authentication type used in the Power BI connector. HTTP is used for anonymous (implicit) authentication, while HTTPS is used for all other types, aligning with Trino security standards.

However, the connector has not been used with LDAP, which would be the [Windows] (https://learn.microsoft.com/en-us/power-query/handling-authentication#authentication-kinds) authentication type in Power BI Custom Connectors. Currently, it only supports Basic (UsernamePassword) and Organizational account (OAuth) authentication types.

Regards, Patrick

LDAP does actually work fine. If Trino is configured to do LDAP auth, then just passing username password works fine.

pichlerpa commented 2 months ago

Thanks for your feedback @bvialmcs, I will close this issue.