如何从SFTP站点将文件加载到Excel Power查询 [英] How to load file to Excel Power query from SFTP site

问题描述

有人可以帮我吗？
我正在尝试从SFTP站点将文件加载到Excel Power Query，但没有看到任何选项。
以下是示例WINSCP SFTP站点凭据：

Can anyone please help me on this? I am trying to load a file to Excel Power Query from the SFTP site and I don't see any option. Following are the sample WINSCP SFTP site credentials:

File Protocol: SFTP
Host Name: ftp.test.com
Port Number: 22
Username: Test1
Password: XXXX

如下面的代码片段所示，我可以从本地C驱动器加载它，但是您可以让我知道如何从SFTP驱动器站点加载它吗？

As shown in the below code snippet, I can load it from my local C drive, but Can you let me know how I can load it from SFTP drive site?

let
Source = Csv.Document(File.Contents("C:\Users\Documents\Winscp\acct_dept.dat"),[Delimiter="|", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}})
in
    #"Changed Type"

< a href = https://i.stack.imgur.com/7Mus6.png rel = nofollow noreferrer>

推荐答案

当前，我认为没有连接器可以执行此操作

Currently, I don't think there is a connector that will do this.

有一个可以投票的Power BI论坛与此相关。

如果您愿意按照<一个href = https://www.reddit.com/r/excel/comments/63wz8a/how_to_load_source_text_data_files_from_an_sftp/ rel = nofollow noreferrer>此Reddit线程，但我不完全了解工作。

There might be possible workarounds if you're willing to do some scripting as suggested in this Reddit thread, but I don't fully understand how that would work.

这篇关于如何从SFTP站点将文件加载到Excel Power查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！