Forum Discussion
VitorAzevedo
5 years agoNew Member
how to avoid Power BI incremental refresh duplicated queries in BigQuery?
I implemented a incremental refresh in a report that gets a lot of data from Google BigQuery. The issue is that each incremental refresh makes duplicated queries, and one of them is pretty expensive....
- 5 years ago
Guys, it turns out that its not possible to avoid those duplicate queries, but there is a way to clusterize BigQuery tables to reduce the amount of processed data!
For more details check this post: https://stackoverflow.com/questions/68956799/how-to-avoid-power-bi-incremental-refresh-duplicated-queries-in-bigquery
VitorAzevedo
5 years agoNew Member
Guys, it turns out that its not possible to avoid those duplicate queries, but there is a way to clusterize BigQuery tables to reduce the amount of processed data!
For more details check this post: https://stackoverflow.com/questions/68956799/how-to-avoid-power-bi-incremental-refresh-duplicated-queries-in-bigquery