Forum Discussion

nklytics's avatar
nklytics
Frequent Visitor
2 years ago
Solved

On Premise FTP Data Source

Which connector we can use to connect to Folder from FTP Server or Network Drive in Dataflow?
Dataflows
  • miguel's avatar
    miguel
    2 years ago

    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.

miguel's avatar
miguel
Community Admin
2 years ago

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's avatar
nklytics
Frequent Visitor
2 years ago

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.