Forum Discussion

MichaelF1's avatar
MichaelF1
Icon for Helper III rankHelper 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
MichaelF1's avatar
MichaelF1
Icon for Helper III rankHelper 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

 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, MichaelF1 

 

I probably understand what you mean, but you may need to change your thought and try to use dynamic data sources by using different dates in table names.

You can refer to it first:

Solved: Dynamic Excel name handling in Power BI - Microsoft Power BI Community

Solved: Re: 2 Parameters - Microsoft Power BI Community

Then if you have any specific questions, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MichaelF1's avatar
    MichaelF1
    Icon for Helper III rankHelper III
    4 years ago

    Thanks v-janeyg-msft I'll check those links out.

     

    Thank you for your help, 

     

    Michael