Scheduling a Refresh with Data from BigQuery

[Anonymous]

Hi All,

We've set up our data pipeline to store data for analytics in BigQuery.  However, we are now realizing that it seems we cannot use a scheduled reload to update data from BigQuery using Power BI Service.

This has been a little misleading up to this point.  Is there a way that I can automatically reload data from BigQuery on a daily basis?  Will this require and ODBC connection and a on premise gateway?  Or am I missing a way to do it directly through the Power BI service?

We've been working on these dashboards for awhile now so I look forward to hearing everyone's thoughts.

Cheers,

Sam

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, if you want to refresh BigQuery data source in Power BI Service, firstly you should connect to BigQuery by the ODBC connector in Desktop and configure gateway in Service. For detailed steps, please refer to this blog: Author and Share Power BI Reports on Real-Time BigQuery Data

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.