Power Query steps gone

[umairarshad]

Team,

I am working on budget consumption analysis of my department. Shifting from Excel pwer query to PBI.

I did follwoing steps. Please read till end.

1. Imported the previous Power query

file -> Import -> Power Query

2.  

3. 

4. 

5.  I changed the source path 

i.e. 

from

"= Folder.Files("D:\Engineering\OneDrive - Emirates Group\00 - Engineering Dashboard\01 - Engineering Dashboard\Raw Data\Spares\01 - Consumption Reports\2021 to Onwards")"

to 

"= SharePoint.Contents(
"https://**********-my.sharepoint.com/******/****_****_*****_***",
[ApiVersion="AUTO"]
)"

I copied and replaces it in the editor.

6. All well went here when pressed enter.

7. Problem starts here. When I click on Table adjacent to "Documents", it prompts to start new navigation step.

8. Whne I pressed Continue, all "Applied Steps" gone.

I dont want to loose that steps. I want to retain them.

Anyone who can help please??

Regards,

[christinepayton]

Don't click on table in the column, just click on your last step on the applied steps on the right instead. Clicking the table is basically replacing your navigation steps, you don't need to do that, you just select the latest step after updating the path. 

[umairarshad]

Thank you for reply. I did it but did not work for me.

[christinepayton]

You are using the folder connector, but I don't see any of the normal folder helper queries in your queries pane. Usually when you use the folder connector there are some extra pieces and parameters that come with it like a sample file query etc. 

I would start a new blank SP folder query, give it your site URL, filter down the path to your folder, and then copy/paste your applied steps over from the other query and see if that works better. You will need to update the first copied step to reference the correct prior step when you copy over. 

[umairarshad]

anyone??