Skip to main content
Microsoft Idea

Power BI

Needs Votes

Connect to Teradata using LDAP Authentication

Vote (168) Share
's profile image

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 (34)
's profile image Profile Picture

on 30 Sep 2021 21:42:22

RE: Connect to Teradata using LDAP Authentication

We dont have the option of LDAP authentication in Power BI service gateway for teradata data source only Basic and Windows option is available. We can enable the LDAP authentication for Power BI desktop but in Power BI service -> Manage Gateways we dont have it. Please add the LDAP authentication.

's profile image Profile Picture

Ajit Kolla on 01 Feb 2021 18:51:29

RE: Connect to Teradata using LDAP Authentication

I am able to connect to Teradata from Power BI Desktop through LDAP mechanism. But once I publish the reports to Power BI service, I am unable to schedule refresh on the dataset as it is failing to authenticate data source credentials. I have personal gateway installed locally on my laptop.

Is this still an issue? Is there a workaround?

's profile image Profile Picture

Kanishk Trivedi on 06 Jul 2020 00:17:07

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.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:11

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.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:53:03

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).

's profile image Profile Picture

Rahul Wagh on 05 Jul 2020 23:52:23

RE: Connect to Teradata using LDAP Authentication

Please add the LDAP authentication feature in Power BI Gateway Level for direct queries.

's profile image Profile Picture

NashB on 05 Jul 2020 23:49:26

RE: Connect to Teradata using LDAP Authentication

What about in the gateway?

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:56

RE: Connect to Teradata using LDAP Authentication

We also need to access to LDAP to recover details from ours users

's profile image Profile Picture

CBB on 05 Jul 2020 23:45:19

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.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:42:10

RE: Connect to Teradata using LDAP Authentication

What command prompt?
I am using the desktop application...

Microsfot: please get this into Power BI

Merged Idea (1)