cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

windows authentication doesn't work in data flow

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:

1.PNG

then I get the following error:2.PNG

 

 

 

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

 

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 !!!!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

 

image.png

 

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.

 

 



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog


View solution in original post

6 REPLIES 6
Highlighted
Super User I
Super User I

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.



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog


Highlighted
Anonymous
Not applicable

@ibarrau 
I already installed a gateway

Highlighted

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

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

 



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog


Highlighted
Anonymous
Not applicable

@ibarrau 

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

Highlighted

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

 

image.png

 

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.

 

 



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog


View solution in original post

Highlighted
Anonymous
Not applicable

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors