How do I get the filename of the excel file I am importing into power bi?
For example if I am importing C:/Path/abc.xlsx, how do I get "C:/Path/abc.xlsx" as a variable. Excel had the method ActiveWorkbook.Name. What is that in power bi?
Thanks
How do I get the filename of the excel file I am importing into power bi?
For example if I am importing C:/Path/abc.xlsx, how do I get "C:/Path/abc.xlsx" as a variable. Excel had the method ActiveWorkbook.Name. What is that in power bi?
Thanks