Sorted Rows is not recognized in Power Query

[Anonymous]

Hello PBI Community.

I am trying to add a query but I am getting an error in that Expression.Error: The name 'Sorted Rows' wasn't recognized. Make sure it's spelled correctly. 

Can you help me with it?

I am actually trying to use an incremental refresh and for that, I am converting my Date/time parameters to synchronized with my Date column, by using said formula. 

and I am using this Link. https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#convert-datetim...

Thank you.

Greg_Deckler

amitchandak

MFelix

@MFlex

[Anonymous · Accepted solution]

HI @Anonymous,

Power query is steps-based languages, normally its query steps are continuous so the next steps will reference the previous step as the source.

According to the error message, it seems like you direct copy the external query steps. I think you need to enter to 'advanced query editor' to copy the 'previous step' name to replace the 'Sorted Rows' to fix the issue.

Regards,

Xiaoxin Sheng

[HotChilli]

Replace #"Sorted Rows" text with the name of the previous step. I haven't looked at the logic for the rest of it but that'll get you further