Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have a report that pulls data from multiple excel files from a folder. The excel file names have data that we'd like to use in the report. Just wondering how to do that using a custom column within power query? How do we get the excel file name as a calculated column within the data table? I'd really appreciate any help.
Hey in this case, you can choose Get data > Folder, once you choose folder, you will see all excel files name in your PQ. then you can do some data cleaning process to shape the data as the format you want in the report. Hope it is helpful!
Hey in this case, you can choose Get data > Folder, once you choose folder, you will see all excel files name in your PQ. then you can do some data cleaning process to shape the data as the format you want in the report. Hope it is helpful!
