Forum Discussion
Google big query supports query folding?
Does big query supports query gilding?
How can i optimize the cost and make my report work faster using big query as source?
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
2 Replies
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.
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
