Power BI

Needs Votes

Connect to Teradata using LDAP Authentication

Vote (168)

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)

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.

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?

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.

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.

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

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.

NashB on 05 Jul 2020 23:49:26

RE: Connect to Teradata using LDAP Authentication

What about in the gateway?

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

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.

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)