Forum Discussion

abalgir's avatar
abalgir
Icon for Helper I rankHelper I
7 years ago

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...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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

  • abalgir's avatar
    abalgir
    Icon for Helper I rankHelper I
    7 years ago

    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