How to connect Google Cloud (SQL BigQuery) to Power BI

[cooperabc]

Hi, 

I really would like to know how to connect Google Cloud (Big Query) to Power Web (Desktop).  My goal is whenever I do have new data or query runs in Big Query, I'd like to see if it is reflected or make changes on Power BI as well.  I will be so happy if anyone can share their knowledge with the steps clearly, I will appreicate that if you can. 

Thank you in advance.

@Omid_Motamedise  @lbendlin @PwerQueryKees @AlienSx @Expiscornovus 

[cooperabc]

Hi @uzuntasgokberk Gokberk - thanks you for your solution and sharing your Linkedin. Your solution helped me and I also know looking for different option if you have any idea here is my new ticket Need to put SQL code/ Query in Power BI desktop an... - Microsoft Fabric Community. I am also open to meet via Teams if that works for you. Thanks ~ Adam 

[uzuntasgokberk · Accepted solution]

Hello @cooperabc ,

You can follow below the step.
Open PBI Desktop --> Get Data --> Google BigQuery --> Fill your Project ID etc. --> Select the table
However, you need to select the table or tables. Whenever another table added in meanwhile, you need to select it. It won't be automatically added the table.

İf you question is you selected for example 1 table and you'd like see automatically refresh in the meanwhile. You can use incremental refresh. Big query supports incremental refresh until query folding supports.
More information for incremental refresh you can follow my medium post:  target=_blank target=_blankhttps://medium.com/microsoft-power-bi/power-bi-hidden-treasure-increment...

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |