cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ElaheMeydani
Level: Powered On

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
ibarrau
Level: Power Up

Re: windows authentication doesn't work in data flow

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.

 

 

6 REPLIES 6
ibarrau
Level: Power Up

Re: windows authentication doesn't work in data flow

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.

ElaheMeydani
Level: Powered On

Re: windows authentication doesn't work in data flow

@ibarrau 
I already installed a gateway

ibarrau
Level: Power Up

Re: windows authentication doesn't work in data flow

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

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

 

ElaheMeydani
Level: Powered On

Re: windows authentication doesn't work in data flow

@ibarrau 

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

ibarrau
Level: Power Up

Re: windows authentication doesn't work in data flow

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.

 

 

ElaheMeydani
Level: Powered On

Re: windows authentication doesn't work in data flow

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 261 members 4,313 guests
Please welcome our newest community members: