Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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
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
User | Count |
---|---|
64 | |
55 | |
46 | |
31 | |
31 |
User | Count |
---|---|
84 | |
73 | |
52 | |
48 | |
43 |