Forum Discussion
campelliann
Post Patron
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...
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
campelliannPost Patron
Post Patron"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
Resolver II
Resolver IIHello
Yes sure you should have access to the other machine