Filename as a column

[Anonymous]

Hi all,

Hoping someone can help me! Does anyone know how to add filename as a column in Power BI? I can do it through connecting to folders but need to be able to do it by connecting to a single excel file.  Thanks 

[v-shex-msft]

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

[Anonymous]

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

[v-shex-msft]

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

[tomcatoggo]

I have the same problem as the thread creator:  I get that error message.

@v-shex-msftwhat 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!