Forum Discussion
Filename as a column
Hi Anonymous ,
I'm not so sure what your requirement, can you please explain more clearly?
AFAIK, if you use folder connector to get data. Power bi will get whole detail information from folder files.(include folder path, filename, Extension...)
Then you can add a custom column with excel connector and merge folder path and file name to get data from specific files.
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
This is a report that I will rolling out to lots of people in different countries so they will run two reports from another system with the results in Excel. I need to create a column that will show the filename as a column. They will possible save multiple reports in the folder so I need them to link to just two of them. When I use the below Custom column formula I get an error:
Error
Is [Folder Path]&[Name] recognised functions or should i actually enter the folder path and file name in here?
Thanks
Hi Anonymous ,
>>Is [Folder Path]&[Name] recognised functions or should i actually enter the folder path and file name in here?
Actually, they are table columns with folder path(X:\xxxxx\) and filename(xxxx.xlsx) strings.
Regards,
Xiaoxin Sheng
I have the same problem as the thread creator: I get that error message.
Anonymouswhat do you mean by:
"Actually, they are table columns with folder path(X:\xxxxx\) and filename(xxxx.xlsx) strings."
Could you please elaborate?
Thank you very much!
