When Datasource is a shared file, authentication doesn't work through gateway.

[Stephnane]

Hello.

We try to create a datasource to access to a file on a shared folder of a server but is says that credentials are invalid.

1) the shared folder is on a server from an Active Directory domain named here "MyAD"

2) The On-premise PowerBI Gateway is not in the same AD domain.

3) The Server who host the Gateway is able to access to the share drive with authentication from the standard Windows Explorer  ( user : MyAD\myusername)

4) When we create the datasource with same credentials , we get the error message : 

Configuration :

Do you have any clue to help us ?

Thank you.

Best regards.

Stephane

[Stephnane]

Hello.

As explained, I tried to access to the shared folder with the Windows Explorer from the server who hosts the gateway (so not on the same AD), and it works well with the credentials of the target domain.

Best regards.

Stephane

[Daryl-Lynch-Bzy]

But why does the connection have username@company.com instead of MyAD/Username?

[Stephnane]

This was our last test, but we also tested MyAD\Username with no success.

[Daryl-Lynch-Bzy]

Hi @Stephnane - the comment that your On-Premise Data Gateway is not on the same Domain worries me.  You need to understand that in the Data Connection configuration panel you are entering your Domain Username and Password to access a specifc drive in the domain network.  But you want the On-Premise Data Gateway to have direct or local access to the file.  This would mean that On-premise Data Gateway needs different credentials and  possibly different file path to the original publisher.  This will explain your error message that credential are incorrect.

Many thanks

Daryl