Forum Discussion

MichaelF1's avatar
MichaelF1
Helper III
4 years ago
Solved

How to edit sheet name in Excel doc when source is a folder

Hi everyone,   I have a PBI report that uses a folder of excel docs as the data source.   I want to change the excel docs and I think I need to change the name of the actual tab in the excel file...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, MichaelF1 

 

I don't understand your question very well, as I mentioned before, it is impossible for powerbi to modify anything in the source data, it can only modify the content displayed in powerquery or desktop.

But I don't see the table name appearing in your steps. Why do you want to modify it? What is the role of what you are trying to modify in pq?

 

Best Regards,
Community Support Team _ Janey

MichaelF1's avatar
MichaelF1
Helper III
4 years ago

Hi v-janeyg-msft ,

 

Sorry if I wasn't clear, I think I've confused myself! Let me start again and ask my question in a different way:

I have a folder of multiple xlsx files as a data source for PBI - (all the same format, but with data for different months). If I want to change one or more of these xlsx files at a later date, do I need to ensure that the sheet names remain the same, for my Power Query code to work?

 

Thanks again

 

Michael