search

CreativeDataEU / PowerBITrinoConnector

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

Trino Authentication PowerBI #31

Closed SrikanthNallela closed 4 weeks ago

SrikanthNallela commented 1 month ago

I have set up trino with username password trying to connect powerbi. my trino is loading correctly

image

https://username:pwd@url:host/mongodb/database is this correct way to pass?

pichlerpa commented 1 month ago

No, you need to choose the authentication method "Basic" in Power BI Desktop or Service once published:

image

SrikanthNallela commented 1 month ago
image

keep getting remote name https could not resolved .my trino is up

image
SrikanthNallela commented 1 month ago

now i gave connection as below. trino is running by self signed certificate

image

selected basic authentication got this error:with user and password image

pichlerpa commented 1 month ago

Can you open Trino in the browser under HTTPS without ignoring the security warning? Do you have your SSL certificate in your root trust store?

SrikanthNallela commented 1 month ago

i have added self signed in my truste

image

but still sme error .this is my trino app

image
pichlerpa commented 1 month ago

It seems like you have a problem with the configuration of the SSL certificate, is also not recognized by your browser.

SrikanthNallela commented 1 month ago

its my test environment fine for me . can you please guide me t resolve this issue in power bi. will have buy for prod environment. dont think its required for test environment

pichlerpa commented 1 month ago

It has nothing to do with Power BI or the connector, it's your SSL configuration. Once you sorted that out, the connector will work. Alternatively, you could just disable HTTPS and use HTTP for testing by connecting anonymously.

SrikanthNallela commented 1 month ago

when trino allows to use self signed and am able to login trino and even connect to superset. why its not allowing powerbi connector?since for test environment we don't want to use licensed certificate. if its doesn't work here we might have to chose external storage to connect mongodb to sql and load data instead of connector ?

pichlerpa commented 1 month ago

You can use self-signed certificates, it's just not configured properly, you can see that in the browser "Not secure". I don't know how Superset is handling that, but maybe it's also running in an "unsecure" context that's why it's working. Remember also to just use the host name to connect, same as in the browser just without the leading "https://".

SrikanthNallela commented 1 month ago

added verify=false in connection in superset to handle ssl . is possible in connector

pichlerpa commented 4 weeks ago

closed due to inactivity.