topic Re: Retrieve username from current data connection in Developer

Retrieve username from current data connection

namratapawale — Tue, 04 Sep 2018 12:03:38 GMT

Hi,

I have a use case where I'm writing a custom M function that requires the username from the current data connector's connection. For example, I am connected to Teradata database using teradata database credentials, and I want to retrieve the username that was used while authenticating to Teradata database in my custom M function.

I'm defining this M function in custom data connector. I tried using Extension.CurrentCredential()[Username] to get the username from credentials but got the following error:

Expression.Error: We can only perform this operation while using a custom data connector.

Is there a way to do this?

Thanks,

Namrata

Re: Retrieve username from current data connection

Greg_Deckler — Tue, 04 Sep 2018 12:41:56 GMT

Looks like another one for @ImkeF

Re: Retrieve username from current data connection

ImkeF — Tue, 04 Sep 2018 13:07:00 GMT

I'm not familiar with this function. If nothing comes up here, I'd suggest asking on GitHub instead: https://github.com/Microsoft/DataConnectors/issues

Re: Retrieve username from current data connection

namratapawale — Wed, 05 Sep 2018 06:27:11 GMT

Hi @ImkeF,

Thanks for the reply!

Extension.CurrentCredential() is mentioned in here in Data Connectors documentation:

https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md#accessing-the-current-credentials

Sure, I'll post this question on GitHub too.

Thanks,

Namrata.

Re: Retrieve username from current data connection

curth — Thu, 06 Sep 2018 11:05:51 GMT

By design (and for security reasons), it is not possible for queries to access credential information.