How to load file to Excel Power query from SFTP site

0 votes

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

I can load it from my local C drive, but Can you let me know how I can load it from SFTP drive site?

Can anyone help me with this? Thanks.

Dec 3, 2018 in Power BI by Shubham
• 13,310 points
324 views

1 answer to this question.

0 votes

Currently, I don't think there is a connector that will do this. There are, however, a few possible workarounds if you're willing to do some scripting as suggested in this reddit thread.

answered Dec 3, 2018 by Upasana
• 8,550 points

Related Questions In Power BI

0 votes
1 answer

Why should I shift from MS Excel to Power BI

There are a lot of advantages from ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 42,410 points
64 views
+1 vote
1 answer

How is power BI different from excel

Power series plug-ins you can do certain ...READ MORE

answered Sep 26, 2018 in Power BI by Hannah
• 16,420 points
48 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 42,410 points
291 views
0 votes
1 answer

Switch Power BI data sources from Excel to Azure analysis services

One option that you should consider would ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 42,410 points
64 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,550 points
53 views
0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,190 points
488 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,190 points
306 views
0 votes
1 answer

Power Query: Custom Columns

This call: FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) replaces the column names ...READ MORE

answered Dec 12, 2018 in Power BI by Upasana
• 8,550 points
46 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,550 points
58 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 8,550 points
336 views