Forum Discussion

filiparibeiro's avatar
filiparibeiro
Helper III
3 years ago

Navigation and excel workbook step

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

Need Help
Show and Tell

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    3 years ago

    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.