Forum Discussion
Pre-filtering/selecting data before Importing to Power BI from Azure Table Storage data source
Thank you for your inputs.
I am more looking into something like oData queries Or Table Storage REST APIs(I am not sure APIs is right approach or not) where we can eliminate columns by putting filter/select.
Something like this -
https://myaccount.table.core.windows.net/Customers(PartitionKey='MyPartition',RowKey='MyRowKey1')
I am new to Power BI and can't find any documentation on how to use oData queries with Azure Table Storage.
Any inputs will be helpful.
Thank you!
- v-robertq-msft
Community Support
Hi, KetD
According to your description, you want to do some oData queries Or Table Storage REST APIs with Azure Table Storage, you can check these documents to find if they can help you:
https://docs.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities
https://docs.microsoft.com/en-us/rest/api/storageservices/query-tables
https://docs.microsoft.com/en-us/rest/api/storageservices/query-entities
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
