change in excel names

[vjnvinod]

Hi,

I was going through a challenge in connecting dynamic excel names into power Bi (Power query) lets say i connected

Global Media and Entertainment Account Listing FY18 P09.xls

Global Media and Entertainment Account Listing FY18 P12.xls

next time my file name changes to

Global Media and Entertainment Account Listing FY19 P01.xls

Global Media and Entertainment Account Listing FY19 P02.xls

in this case my refresh option fails and i need to reconnect to P01 and P02.

How do i achieve this, without reconnecting the source file again and again?

[v-piga-msft]

Hi @vjnvinod,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[vjnvinod · Accepted solution]

@v-piga-msft

this doesnt solves the problem, as everytime i can't be expected to go to advance editor and change the source line.

hope to get some solution soon

[Greg_Deckler]

In Power Query, use the Advanced Editor and edit your Source line.