Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Scheduling a Refresh with Data from BigQuery

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

Dataflow

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.