Forum Discussion

cooperabc's avatar
cooperabc
Frequent Visitor
1 year ago
Solved

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

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 

Tutorial Requests
  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago

    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-incremental-refresh-7e91ac79fc6a

    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 |

2 Replies