Google Tables Connect to PBI - Area120?

[Jbrunson09]

All,

Ive searched the boards and didnt find anything that answered this question. If this already exists, please just direct me to the discussion.

Im trying to connect Googles "Tables" program to power bi. Tables is googles version of smartsheet for those unfamilar. has anyone had any luck on how to connect "Tables" to power bi to pull data?

Any info on this (even if its to tell me its impossible) is appreciated.

Link to tables: Home - Tables (google.com)

Thank you

[v-kongfanf-msft · Accepted solution]

Hi @Jbrunson09 ,

You can try below steps to connect google tables to powerbi.

Convert your google tables to sheets.

copy your sheet url link in powerbi GoogleSheets like below

verify your google identity in powerbi

connect to google sheet successfully

One thing to note is to be sure to provide the correct url, powerbi does not support direct connection to google table.

Power Query Google Sheets connector - Power Query | Microsoft Learn

Best Regards,
Adamk Kong

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