Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Filter to azure table storage from the URL

    Vote (38) Share
    John Jairo Bocachica Villate's profile image

    John Jairo Bocachica Villate on 25 Jul 2016 04:44:19

    Azure table storage rest services allow us to query a table with parameters, we must have the same features from the azure table storage datasource, for now, we have to import all the table and then filter it.

    https://myaccount.table.core.windows.net/mytable(PartitionKey='',RowKey='')?$select=

    Comments (2)
    John Jairo Bocachica Villate's profile image Profile Picture

    Rob Rainey on 05 Jul 2020 23:27:36

    RE: Filter to azure table storage from the URL

    The ability to provide a $filter or $select (or both) to a table storage query would be great and reduce the amount of data needed significantly

    eg:

    $select=PartitionKey,RowKey,Timestamp,Field1,Field2,Field3&$top=1000&$filter=(RowKey ge 'Example' and RowKey lt 'Example~') or (RowKey ge 'Value' and RowKey lt 'Value~')

    John Jairo Bocachica Villate's profile image Profile Picture

    Sebastian Rösch on 05 Jul 2020 22:49:00

    RE: Filter to azure table storage from the URL

    I am interested in using other query params as well, like TOP N, as described here:
    https://docs.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities