Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Which connector we can use to connect to Folder from FTP Server or Network Drive in Dataflow?
Solved! Go to 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.
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.
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.
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!