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

Authentication Details #26

Closed 123srikan closed 2 weeks ago

123srikan commented 3 weeks ago

can you please share details about how to provide and configure authentication this connector

pichlerpa commented 3 weeks ago

could you please be more specific? Which authentication type do you want to use, username/password or OAuth2? What's the problem you are facing?

123srikan commented 3 weeks ago

Thanks for quick response. i want to use username/password for authentication. if we can add users ,How can we configure multiple users. Also is it possible to restrict collection and only show specific collection.as i don't want end user to see other collections from mongo db image

pichlerpa commented 2 weeks ago

You can apply OLS in Power BI. Is this what you are looking for? Otherwise, please explain your use-case a little further.

123srikan commented 2 weeks ago

My mongodb database is used by other user for generating reports in PowerBI. this user will use Powerbi .i have shared this connector details so that he can use this mongo db data in this PowerBI app . I dont want user to see other secured data which is not useful to him . since there is no restriction on data, user can see other data.Is it possible to enable authentication in connector and also restrict user to see only specific collection. since my database is used by other user he can still see other collection. I take care of Mongo data, am not into power Bi reporting. Please let me know if you get my request?

pichlerpa commented 2 weeks ago

I try to summarize:

I hope this answers your question.

123srikan commented 2 weeks ago

thank you very much for quick response. For report viewers: You can manage access control directly within Power BI to restrict what data they can see. My comments:yes this be will taken care by PowerBI developers For report authors: They access the data source directly using the credentials provided, with no alternative workaround. However, you could create multiple Trino users and set up access controls in Trino to limit data access accordingly. my comments: This i have to check .How will restrict my data to see only limited data. Will check and let you know in case of any queries

pichlerpa commented 2 weeks ago

This might be what you are looking for: https://trino.io/docs/current/security/file-system-access-control.html

I will close this issue as it's not directly related to the connector.