windows authentication doesn't work in data flow

[Anonymous]

I have my table in powerbi desktop, and I want to put it to powerbi data flow. I simply copy the query and in the data flow:

then I get the following error:

and then when I click on edit credintials, I have this: 

Then no matter what I enter in the windows authentication, it doesn't work, I tried the following:

- my email

- my windows log_in

- AzureAD\myUsername

- fileserver\sharedfile\username

- I started my browser as 'run as an administrator'

none of them are working. Can someone tell me what is wrong, please !!!!!

[ibarrau]

Hi. You probably need an On Premise Data Gateway installed on the pc in order to connect DataFlows to an on premise data source like the csv with that path.

Then you can connect that way.

[Anonymous]

@ibarrau 
I already installed a gateway

[ibarrau]

Is that gateway configured with the source (csv file) ?

You should type the same credentials you use for login your pc.

[Anonymous]

@ibarrau 

how should I configure the gateway with (scv)format?

[ibarrau · Accepted solution]

After installing the gateway with you account, you can go to configuration and Manage gateways like this:

There you can add a source and check if the autentication works. Once you manage to connect there you will be able to use the same credentials on dataflows.

[Anonymous]

@ibarrau 
Oh my god!!!!!!!!
I can not believe that it is working !!!!!