Navigation and excel workbook step

[filiparibeiro]

Hello.

Has anyone ever faced his issue: in power query my navigation step has a path to a folder and when I import the excel workbook it shows a path to a different folder, which is the wrong one, and still is able to get the corret file (in the first folder). I can only correct this by changing navigation step and this will delete all following steps in the query. So, is there anyway to corret the 2nd path without having steps deleted? And why is this happening?

Thanks in advanced

[AlB]

Hi @filiparibeiro 

You can change the path directly on the code in the Advanced Editor

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.