On Premise FTP Data Source

[nklytics]

Which connector we can use to connect to Folder from FTP Server or Network Drive in Dataflow?

[miguel · Accepted solution]

There isn't an FTP or SFTP connector Power Query today. You can suggest such connector as a new idea on aka.ms/FabricIdeas or you can also leverage the FTP connector in Data Pipelines to load the data to a Lakehouse and then use a Dataflow against the loaded data.

[nklytics]

Hi Miguel

Thanks for the reply. It's really strange. I am just working on it. I successfully created a data source of connection type FTP using Gateway Connection but I can't use it in dataflow. I tried connecting using folder connection type but then every time I try to validate using Window Creds, it throw error of Invalid Credentials. I have been searching whole internet but no solution found that works. And it's common issue but no where it is explained how to get windows username and password to successfully use the gateway.

I will post that in Ideas, definately.