Selectively refreshing only one query

[JonSwed]

Hi all!

I'm connecting to Google Analytics data via BigQuery. Nice.

A recent migration in our BigQuery set up has resulted in two tables of Google Analytics data. An old query, containing the pre migration data, and a new query, which is the post migration data.

I'm figuring out how to best append these in Powerbi. The schema's are identical.

Is it possible to only refresh the new query, and not refresh the old query?

[amitchandak]

@JonSwed , refer if the second approach can work in your case too

https://helicaltech.com/disable-data-refresh-local-data-source-powerbi/

[JonSwed]

Thanks for the quick reply.
That 2nd approach looks promising, but do you think this will work with  dataset which is 9 million rows?

[Anonymous]

Hi @JonSwed,

Did these GA instances use the same connection?

If that is the case, I'd like to suggest you export old version records and import them to power bi as new query tables. (old version records will be lost if you apply refresh on these query tables and apply the change to generate new data model tables)

Power bi data model instance 

Regards,

Xiaoxin Sheng

[JonSwed · Accepted solution]

Hi there, thanks for that. No, they are separate queries. I solved the problem by two different datasets being merged in BigQuery, which meant I only had to connect to one dataset.
Thanks for the help and advice.