While i was struggling with renaming a csv sheet i discovered a solution. My need was to save daily a csv and rename with date but further for power bi the need was to load all csv from folder and sheet name to be the same to all.
So the csv doesn’t have sheets so it takes its name.
the solution is to have a csv constant name with minumum 31 characters; the sheet name is limited and if you put at the end date or something variable won’t appear in the sheet name
Hope someday will help someone!