Query folding not supported in Azure Table storage

[Anonymous]

I am having an Azure table storage , where I am connecting data to my Power Bi Desktop and since there is a large amount of data coming up , I was looking to implement incremental refresh but what i see is "View native query" is disabled and that prevents me from creating incremental refresh functionality. Can someone please help here as why this is disabled. Source is Azure Table storage 

[Shach]

Hi,

Did you find a solution for this ?

[v-rzhou-msft]

Hi @Anonymous 

For reference: Sources that support folding

Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.

Azure Table storage should be a table api not same as relational database like SQL.

For reference: Blog

Best Regards,

Rico Zhou

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

[Anonymous]

ATS is a non relational database and it does have query language support in it just like SQL and tht is why I belived it should support Query folding