cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abalgir Regular Visitor
Regular Visitor

How to load a csv from a remote host Power BI desktop

Hello,

 

I have a csv file saved on a Digital Ocean droplet. I need to load this csv in Power BI desktop to do some analysis.

 

How I can configure that in Power BI. I have the ssh right to the droplet set correctly.

 

Thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to load a csv from a remote host Power BI desktop

Hi @abalgir ,

Based on my test, PowerBI desktop cannot support ssh directly, as a workaround, we can select one from the following methods:

Configuring FTP on remote server, PowerBI can use an FTP URL through the "From Web" connector.

Another workaround is using Python script to get csv file via ssh, then convert it to Pandas data frames, after that import PowerBI desktop.

Read a file from server with SSH using Python: https://stackoverflow.com/questions/1596963/read-a-file-from-server-with-ssh-using-python

(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)

Run Python scripts in Power BI Desktop:https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts

 

Best Regards,

Teige

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to load a csv from a remote host Power BI desktop

Hi @abalgir ,

Based on my test, PowerBI desktop cannot support ssh directly, as a workaround, we can select one from the following methods:

Configuring FTP on remote server, PowerBI can use an FTP URL through the "From Web" connector.

Another workaround is using Python script to get csv file via ssh, then convert it to Pandas data frames, after that import PowerBI desktop.

Read a file from server with SSH using Python: https://stackoverflow.com/questions/1596963/read-a-file-from-server-with-ssh-using-python

(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)

Run Python scripts in Power BI Desktop:https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts

 

Best Regards,

Teige

View solution in original post

abalgir Regular Visitor
Regular Visitor

Re: How to load a csv from a remote host Power BI desktop

Thank you,

I checked the Python script, it has limitations to :

Dataframe size

150,000 rows

 

My data is 100 millions rows and growing, and needs to be refreshed on a schedule. 

 

I also found out in a blog that Power BI does not support ftp  scheduled refresh method , which is a need for me 😞

 

I appreciate the help

Gerard

 

 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)