Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rename excel sheet from multiple files

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

Need Help
Tutorial Requests

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, yes I'm using a Folder Query 

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago
        Well, that's a pickle then. Any rhyme or reason for the sheet naming convention?