Forum Discussion
Filtering a query (limiting data) using Power BI and Azure Table Storage
Hi! Is it possible to filter a query into an Azure table through the AzureStorage.Tables() connector in order to limit the amount of data transfered in the response? Best, Per
PerK,
It is not possible to filter a query into the built-in Azure Table storage connector in Power BI Desktop. We have to import all tables firstly and then filter the data in Power BI Desktop.
In your scenario, you can use Azure table storage rest api as a workaround, it is possible to query a table with parameters. For more details, please review the following article. Meanwhile, please vote up this idea.
https://docs.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities
Regards,
Lydia