Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
jhuamani
New Member

Prefilter Azure Table Storage Data

Hi, I have data in Azure Table Storage that I'm attempting to use Incremental Refresh on when using the Azure Table Storage Connector. However, I've noticed that when using the connector all the data in my tables gets imported, which sometimes is causing me timeout issues, despite having subsequent filters on the Partition and Row Keys. I'd like to know if it's possible to pre-filter Azure Table Storage data on the Partition and Row Keys during the initial import. I've found this information on querying Table Storage but there is no option to apply a simple query via the Table Storage Connector. Thank you!

1 REPLY 1
Anonymous
Not applicable

Hi @jhuamani 

After testing, you can consider to use api to filter, then select web connector,  you can refer to the following link.

Querying tables and entities (REST API) - Azure Storage | Microsoft Learn

And you can also refer to the following similar thread.

Pre-filtering/selecting data before Importing to P... - Microsoft Fabric Community

powerbi - How to pre filter the data Set before loading all the data in Power BI - Stack Overflow

powerquery - How to efficiently filter Azure Table Storage data in Power Query - Stack Overflow

 

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.