Connecting to a csv file / folder on remote machine

[campelliann]

Hi there, 

Is this possible? If I have the VPN on and I am logged into the remote machine, is it possible for powerbi to get data from the remote machine? How would this work with a csv file on my remote desktop for example

Thanks

[CharbelArmaleh · Accepted solution]

Use the bellow code

let
Source = Excel.Workbook(File.Contents("\\<computer-name>\<folder-path>\<filename>.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true])
in
#"Promoted Headers"

And when you provide the drive E: don use the :

Example

\\99.999.999\E\Users\userID\Desktop\filename.xlsx

Try to open the link and check if you can access the folder from your pc before importing it to power bi

[Vishnu1995]

Is this possible for connect to remote linux machine?

[campelliann]

"DataSource Error: The network path was not found". I have powerbi desktop on my physical machine with my company credentials perhaps I need some sort of authorization...

[CharbelArmaleh]

Hello

Yes sure you should have access to the other machine 

[CharbelArmaleh]

Hello,

You should provide the full path of the csv file

another thing that you can do is to share the file and use the share path into power bi

ex: \\Myfiles\file.csv

Did I answer your question? Mark my post as a solution!

[campelliann]

Hello, and thank you for the message. 
I was trying something along these lines unsuccessfully...  Remote machine IP and then the path...

= Excel.Workbook(File.Contents("99.999.999\E:\Users\userID\Desktop\filename.xlsx"), null, true)