Hi Guys
Please take a look at the picture below that should describe my situation.
How do I go about adjusting my below Power Query Navigation expression that takes into account that the "Sheet Name" (i.e. Navigation expression) is variable each time the below excel report data and saved from our system, even though the "File Name" (i.e. Source expression) remains constant each time I save the excel report data.
Please take a look at the picture below that should describe my situation.
How do I go about adjusting my below Power Query Navigation expression that takes into account that the "Sheet Name" (i.e. Navigation expression) is variable each time the below excel report data and saved from our system, even though the "File Name" (i.e. Source expression) remains constant each time I save the excel report data.
Power Query:
let
Source = Excel.Workbook(Web.Contents("https://eznlb-my.sharepoint.com/personal/m_pinto_enzazaden_com/Documents/(Shared%20by%20Me)/Apps/(Enza%20Data%20Sources)/Cubes/[COLOR=rgb(44, 130, 201)][B]ABS%20Order%20Lines%20Batches.xlsx[/B][/COLOR]"), null, true),
#"ABS Customers_Sheet" = Source{[Item="[COLOR=rgb(184, 49, 47)][B]ExportData_MICHAELP_214[/B][/COLOR]",Kind="Sheet"]}[Data],