Excel name change

[vjnvinod]

Below is my excel source location.

Excel.Workbook(File.Contents("C:\Users\Vinod.Vijayan\Desktop\TMT Processes\Power BI Projects\Region trade flow automation project\Engagment data monthly Input\Pipeline\Global TMT Sales and Pipeline Listing FY20 P8 WK2.xlsx"), null, true),
    Wins_Sheet = Source{[Item="Wins",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Wins_Sheet, [PromoteAllScalars=true])

I was trying to figure out a way  to dynamically change the source

For instance, my current source is excel with below name

Sales and Pipeline Listing FY20 P8 WK2.xlsx

Is there a way I can use file name contains “Sales and Pipeline Listing”? so that I don’t have to keep changing the source.

 

[v-lionel-msft]

Hi @vjnvinod ,

Maybe you can refer to Updating a Changing Data Source File Name  .

Best regards,
Lionel Chen

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

[Daviejoe]

Hi @vjnvinod 

Will this be the only file in this folder?  If so just use Get Data from Folder.

[amitchandak]

@ImkeF , can you help?