extract and filter data on Azure Table Storage side via Table Storage connector?

[Anonymous]

I have below RowKey in my azure table storage which I am able to filter using the line below. The row key is combination of values and a datetime value. Is it possible to extract the date time from row key and then do a filtering on server side.  

Here is the row key> 

PECKLL06620200629T003609.054Z 

here first 9 letter is some values and restare date time in ISO format

filtering:

Table.SelectRows(cableassemblyresults1, each ([RowKey] > "PECKLL06620210408T065014.561Z" and [RowKey] < "PECKLL06620210408T065018.727Z"))

[amitchandak]

@Anonymous , Try a new column in power query if that can help

DateTime.FromText(Text.End([column], Text.Length([column]) -9))

[Anonymous]

@amitchandak Filtering done over this new column will be happening on Server side?