Configuring connection in dataflows

[shlomiweiss]

Hi all

I'm new with Power BI, trying to work  with dataflows

I've copied a query from my local Pwer BI desktop to the dataflow service

I get a message to configure my connection, but when I click on it , the the following screen

It's a simple excel file in my file server

But when cllick on Authentication kind, I have only (none)

Any ideas?

Shlomi

[Fowmy · Accepted solution]

@shlomiweiss 

You need to install a Gateway and create a connection to the file on your local drive. 

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install