on 16 Oct 2015 21:52:04
My organisation requires connections to Teradata to use LDAP authentication. This option should be available in PowerBI. It was previously requested in Power Query but is not yet delivered: https://social.technet.microsoft.com/Forums/en-US/2c3c74a8-6ef9-4c34-8dec-83d21d041e39/how-to-connect-to-teradata-with-ldap-authentication-via-powerquery?forum=powerquery
- Comments (32)
RE: Connect to Teradata using LDAP Authentication
Please add LDAP authentication mechanism for PowerBI gateway in PowerBI server
as it is needed to authenticate users using LDAP mechanism in desktop to refresh their reports.
Power BI supports LDAP in desktop if we add LDAP to it by running the below command in CMD:
PBI_EnableTeradataLdap true
but their is no LDAP authentication mechanism in data source credentials in the Power BI server.
Please do add the LDAP authentication method in the power BI gateway to in the server.
RE: Connect to Teradata using LDAP Authentication
Hello. My organisation is using teradata as one of our primary datawarehouse infras. We need this option (LDAP) to work in order to get enduser authentication passed to Teradata from our Power BI reports.
RE: Connect to Teradata using LDAP Authentication
Very important to add this feature in Power BI Gateway and set this configuration as default in Power BI Desktop (nowadays is necessary run a command on CMD).
RE: Connect to Teradata using LDAP Authentication
Please add the LDAP authentication feature in Power BI Gateway Level for direct queries.
RE: Connect to Teradata using LDAP Authentication
What about in the gateway?
RE: Connect to Teradata using LDAP Authentication
We also need to access to LDAP to recover details from ours users
RE: Connect to Teradata using LDAP Authentication
Setting the flag as mentioned below worked for us as well. We are able to successfully connect Power BI desktop to Teradata using LDAP now.
More here: https://community.teradata.com/t5/Connectivity/Excel-2010-connectivity-We-couldn-t-authenticate-with-the/td-p/83900
Steps: Open "Command Prompt" and type/paste "PBI_EnableTeradataLdap=True". Press enter and open/restart Power BI Desktop and create a new connection using the Teradata connector. When prompted for authentication you will now see an option for LDAP. Note you will need a recent (January+) version of Power BI Desktop for this to work.
RE: Connect to Teradata using LDAP Authentication
What command prompt?
I am using the desktop application...
Microsfot: please get this into Power BI
RE: Connect to Teradata using LDAP Authentication
I confirmed that the solution "setx PBI_EnableTeradataLdap true" in the command prompt works.
RE: Connect to Teradata using LDAP Authentication
I confirm that solution with setx PBI_EnableTeradataLdap true works.
Thanks!