Rename excel sheet from multiple files

[Anonymous]

Hello everyone,

New to the Power BI world.

I'm trying to load multiple excel files that contain a different sheet name in each file. The formating is the same.

Is there a way of changing the sheet name? 

thanks,

Yair

[Greg_Deckler]

If you are loading them individually yes. Are you using a Folder query?

[Anonymous]

Hi, yes I'm using a Folder Query 

[Greg_Deckler]

Well, that's a pickle then. Any rhyme or reason for the sheet naming convention?

[Anonymous]

Yeah..that's how the data is received

Thanks anyway!

[Greg_Deckler]

Well, if there is a pattern to it, you could potentially solve it in Power Query, that's why I was asking if there was some kind of pattern.

[Anonymous]

What kind of pattern are you referring to? the files are in the same format.

Just the names of the file and sheet are different.

[v-juanli-msft]

Hi @Anonymous 

Why do you need to change the sheet names/file names?

Do you want to append them in power query or anything else?

How do the "renaming sheet names/file names" help you for your purpose?

Best Regards

Maggie