Filtering a query (limiting data) using Power BI and Azure Table Storage

[PerK]

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

[Anonymous]

@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