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
AlienSx's avatar
AlienSx
Super User
3 years ago

Hi, MartinDUK use Csv.Document(FilePath) Csv.Document(File.Contents(FilePath)). Add optional parameters if you need to (delimiter, number of columns etc.). Simply read (get data from) that CSV file (PQ creates all parameters for you) and replace "...path..." value by your FilePath query name. 

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