Google big query supports query folding?

[Anonymous]

Does big query supports query gilding? 

How can i optimize the cost and make my report work faster using big query as source? 

[ppm1 · Accepted solution]

How much data do you have in Big Query? If possible, it is better to import your data. It will be more performant and you'll only be querying during refresh (which you should do with incremental refresh to speed things up and further reduce the volume of queried data).

Pat

[amitchandak]

@Anonymous , As per document, the only excultion is

https://learn.microsoft.com/en-us/power-query/power-query-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.