Connecting to a csv file / folder on remote machine

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