cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DeepDive
Helper IV
Helper IV

SFTP/FTP files access

Hello all,

 

Is there any direct way, that I could connect my PBI to access files placed in SFTP/FTP. Also I want to enable scheduled refresh.

ps : files will be updated on daily basis in SFTP folder.

 

Any reference link/tutorial , pls share. thanks.

 

 

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @DeepDive 

 

Based on my research, there are several ways that are offered.

1. You can use FTP commands or third-party tools to bring files down to local folder, then connect to the folder by using the Get Data ->Folder option in Power BI Desktop.

2. You can use Microsoft Flow to automate the extraction of your data from the FTP server to your OneDrive or SharePoint.

 

See the links below for more information:

https://community.powerbi.com/t5/Power-Query/connection-with-ftp/td-p/91792

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=3313bc81-...

https://www.linkedin.com/pulse/how-connect-microsoft-power-bi-data-sftp-ftp-marcos-fattibello

https://community.powerbi.com/t5/Desktop/Connect-Power-BI-to-FTP/m-p/503802

https://www.cdata.com/kb/tech/ftp-odata-power-bi.rst

https://www.cdata.com/kb/tech/sftp-powerbi-dataflows.rst

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
v-angzheng-msft
Community Support
Community Support

Hi, @DeepDive 

 

Based on my research, there are several ways that are offered.

1. You can use FTP commands or third-party tools to bring files down to local folder, then connect to the folder by using the Get Data ->Folder option in Power BI Desktop.

2. You can use Microsoft Flow to automate the extraction of your data from the FTP server to your OneDrive or SharePoint.

 

See the links below for more information:

https://community.powerbi.com/t5/Power-Query/connection-with-ftp/td-p/91792

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=3313bc81-...

https://www.linkedin.com/pulse/how-connect-microsoft-power-bi-data-sftp-ftp-marcos-fattibello

https://community.powerbi.com/t5/Desktop/Connect-Power-BI-to-FTP/m-p/503802

https://www.cdata.com/kb/tech/ftp-odata-power-bi.rst

https://www.cdata.com/kb/tech/sftp-powerbi-dataflows.rst

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors