Forum Discussion

MartinDUK's avatar
MartinDUK
New Member
3 years ago

How do I Use Text from Cell Drill Down as Data Source and File location.

  I have files in a Network Folder and have written a query to get the list of files from a Folder. Filtered the File name for the relevent file. Filtered the Latest file. Drilled down in the Cel...
Need Help
Show and Tell
Tutorial Requests
MartinDUK's avatar
MartinDUK
New Member
3 years ago

I'm sorry I don't understand that, im quite new to Power BI.

All I want to do is select a file from a Network Drive, the File name changes every day by adding the Date at the end of the File. So I did the query to filter the file name and location but do not have the knowledge to use this txt to get the Excel file from the Network Location.

AlienSx's avatar
AlienSx
Super User
3 years ago

create blank query, open it with Advanced Editor and literally write the following 

 

let 
  // Source = Csv.Document(FilePath) - wrong!
   Source = Csv.Document(File.Contents(FilePath))
in Source

 

what do you get?  

  • MartinDUK's avatar
    MartinDUK
    New Member
    3 years ago

    I get the file and File Path, which I've already got.

    How do i use this to import the Excel file displayed?

     

     

     

    • AlienSx's avatar
      AlienSx
      Super User
      3 years ago

      I am sorry, my fault. Try this please

      let 
  Source = Csv.Document(File.Contents(FilePath))
in Source