Forum Discussion
Get Data from Azure Storage Table
In my experience query folding is limited to data sources that expose some sort of SQL interface (including Oracle, and even SFDC). Yours sounds more like a blob storage and would have to be ingested as is before applying the transforms.
Does anyone know whether power bi first loads the data and then performs the transformation or the query is executed on the source and then I get the remaining data for this specific source?
That depends on the transforms you do. Have you heard about "Query Folding" yet?
Queries from Power BI Desktop do not usually time out. Your timeout must come from the Azure Storage source.
Consider using incremental refresh.
Hi, thank you for your answer. I guess my question should be better phrased as does power query support query folding for Azure storage table. In my tests does not seem to do so (even by applying basic transformations). I was hoping if someone could have earlier experience on that which could help.
In my experience query folding is limited to data sources that expose some sort of SQL interface (including Oracle, and even SFDC). Yours sounds more like a blob storage and would have to be ingested as is before applying the transforms.
