Hi everyboby
My organisation use Synology Active Directory Server based on "Simba" ...
With this Active Directory everything is working fine.
When I setup the gateway, everything is ok, my active directory account is recognised and I have the message "Online : you are good to go"
But when I want to add a dataset, it's not possible it seem it doesn't recognised the UPN...
So In the file "Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll" I have change :
setting name="ADUserNameReplacementProperty" serializeAs="String"
value UserPrincipalName value
setting
setting name="ADServerPath" serializeAs="String"
value
setting
setting name="ADUserNameLookupProperty" serializeAs="String"
value emailAddress value
setting
In the gateway log I found the following message
DM.EnterpriseGateway Error: 0 : 2020-01-19T16:33:54.7068412Z DM.EnterpriseGateway c1aa34ba-ee37-45ed-b8bb-98c35f89b70d db581c3f-71df-53e7-761e-65306475b7b0 MGCC c632fdfe-df67-4d84-8f96-6001e4a7bae7 fd948724-3850-4f4a-8c50-f76b989d548b fd948724-3850-4f4a-8c50-f76b989d548b F9773A87 [DM.Pipeline.Common] Query result is null on ADServer Default. LookupPropertyName:'emailAddress'. LookupPropertyValue:'m****.p****@e***.fr'. TargetPropertyName:'UserPrincipalName'.
DM.EnterpriseGateway Error: 0 : 2020-01-19T16:33:54.7068412Z DM.EnterpriseGateway c1aa34ba-ee37-45ed-b8bb-98c35f89b70d db581c3f-71df-53e7-761e-65306475b7b0 MGCC c632fdfe-df67-4d84-8f96-6001e4a7bae7 fd948724-3850-4f4a-8c50-f76b989d548b fd948724-3850-4f4a-8c50-f76b989d548b 0CD5D09F [DM.Pipeline.Common] Query ADServers Failed. Fall back to original value.
DM.EnterpriseGateway Error: 0 : 2020-01-19T16:33:54.7850778Z DM.EnterpriseGateway c1aa34ba-ee37-45ed-b8bb-98c35f89b70d db581c3f-71df-53e7-761e-65306475b7b0 MGCC c632fdfe-df67-4d84-8f96-6001e4a7bae7 fd948724-3850-4f4a-8c50-f76b989d548b fd948724-3850-4f4a-8c50-f76b989d548b BAA79098 [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source.; ErrorShortName: AdomdDataAccessErrorResponseException[ErrorCode=-1056899072,HResult=-2146233088]/Wrapped(AdomdErrorResponseException)[ErrorCode=-1056899072,HResult=-2146233088]
Please could you help me ?
Thank you in advance
BR
