Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Query folding not supported in Azure Table storage

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 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      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