Forum Discussion
Extraction of Excel File name automatically in Power BI dash board
Dear all, I want my BI dashboard to extract excel file name automatically for that may be I need to create a column and use a code to get the name. so please any one can guide me or tell me which c...
1. I am taking the file from local folder.
2. In the screen shot I have marked that when we choose source data folder it taked file names automatically by adding new column and what I want is same column with file name in my excel data sheet.
foodd
Community Champion
Community ChampionSo, you have the File Name already. Good.
What you need is the worksheet name or names from the workbook.
Are the Excel Workbooks the same structure (count of sheets) from day to day?