Scheduling a refresh for Google BigQuery

[abhitiwa]

Hi guys

I am trying to schedule an automatic refresh for my PowerBI dataset. It contains Google BigQuery as one of the data sources, and thus I'm unable to proceed here.

Can someone suggest what could be done here?

Thanks

Abhishek

[v-piga-msft]

Hi @abhitiwa ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[abhitiwa]

Hi @v-piga-msft 

Many thanks for your response, and apologies for not reverting back earlier.

I understand the process which you shared, however, I am looking to add Google BigQuery as a datasource here. This is something which seems missing from the list of sources. Any clue on how to get this added?

Thanks

Abhishek

[v-piga-msft]

Hi @abhitiwa ,

I have a little confused about your scenario.

Do you have other data source in this report?

Normally, if we need set schedule refresh for the dataset in power bi service, we need to install the on-premises data gateway and add the data source in the gateway. 

If you data source is online source, you also could select this option when you configure the data gateway.

If your report contains more than one data source, you need to add all the data source in the data gateway. 

Best  Regards,

Cherry