Importing .txt files into Power Bi using Python

[Karolina411]

Hello

I am trying to read .txt Claims files into Power Bi (june 2023 version).  Here is what it looks like: 

1) I import .txt files into Power Bi - done

2) Show the most current date - done

3) Write code to turn most recent file into a dataframe (in the column under FOLDER PATH) - I cannot seem to do it w/o getting an error message

Also--I am already reading the file into a column where the path is but my DAX code is not working:

[Brunner_BI · Accepted solution]

I think you can only use in a python or R visual any data that you drag and drop into the visual.

Meaning you would need to put all columns in the visual first and it will automatically create a dataframe for that but it does not allow any access to anything else.