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

Is it possible to load CSV data from a remote host?

Hello,

 

I want to connect to a CSV file from a different windows machine. of course I have the remote host IP , the correct rights (I can ssh, sftp,...).

I have no idea how to proceed in power BI Get Data Text/CSV...

When I try Get Data Web and put in the URL field:  XXX.XX.XXX.XXX:/srv/file.csv

I get :

Unable to connect message 

Deatails: "Web.Content failed to get contents from 'https://website.com/srv/file.csv' (404): NOT FOUND"

 

I appreciate any help

 

Thank you all

Gerard

2 REPLIES 2
Community Support Team
Community Support Team

Re: Is it possible to load CSV data from a remote host?

HI, @abalgir 

If you could script retrieving your file using your SSH client first. Likely, you could use PowerShell and script the SSH retrieval then the Power BI data manipulation/presentation.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
abalgir Regular Visitor
Regular Visitor

Re: Is it possible to load CSV data from a remote host?

Thank you Lin,

 

If by script you mean Python, I read that Python script in Power BI has a limitation to 150,000 rows for a dataframe.

 

My data is 100 millions rows and growing.

 

I am not sure it will work 😞

 

Thank you for the help

 

Gerard

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,091)