topic Re: On Premise FTP Data Source in Dataflow

On Premise FTP Data Source

nklytics — Mon, 04 Mar 2024 17:28:21 GMT

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

Re: On Premise FTP Data Source

miguel — Mon, 04 Mar 2024 18:55:09 GMT

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.

Re: On Premise FTP Data Source

nklytics — Mon, 04 Mar 2024 19:02:52 GMT

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.