I have kind of a funky thing here. I have a report connected to some folders, with Excel files, including the name of the folders and excel files as a column in my query is no issue, however, I also want to create a column that contains the name of the PBIX file I am working in. This needs to be dynamic, i.e creating a column hard coding the name of the PBIX file is not an option because the file will be copied and the name changed depending on the period.
The reaon I need the name of the PBIX file as a column, is so I can match up the PBIX file with the relevant files in my source folders dynamically.
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.
Community Support Team _ Cherie Chen If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.