Hello everyone! First post in this community
I am new to Dremio, kind of testing it out to see if I can use it for my reporting needs. I currently use PowerBI Dataflows and am trying to convert my tables from the M format to the Dremio SQL.
A problem I recently come across is the name of the source file, I have a series of excel files which are being converted to a physical table
I’d like to know what the source file name is as this is an important piece of information for me, is it possible to keep this data in the Dremio table or would the only solution be to add it to the file itself?