Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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"))
 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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