Forum Discussion

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
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.

v-janeyg-msft

Community 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.