Power BI with Google BigQuery

[Zzema]

Hello, can't find answer on this problem:

How to connect tables through ODBC (google big query), if they have the same structure for each day. i.e:

Sales_history_2017_01_01

Sales_history_2017_01_02 and so on.

I tried to add an SQL statement, but, as I understood, power bi does not support Table_Date _range construction.

[v-ljerr-msft · Accepted solution]

Hi @Zzema,

Have you tried the Append option or Table.Combine(M) to combine all the sales history tables which have the same structure into a single table? 

Table.Combine({Sales_history_2017_01_01, Sales_history_2017_01_02, Sales_history_2017_01_03})

Regards

[Greg_Deckler]

Could you do an Append query? Perhaps I am not understanding what you are going for though.