Forum Discussion
Post PatronConnecting to a csv file / folder on remote machine
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
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
7 Replies
- CharbelArmaleh
Resolver II
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!
campelliannHello, 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)
- CharbelArmaleh
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
- 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
Vishnu1995Helper I
Is this possible for connect to remote linux machine?