Forum Discussion

Frequent Visitor

9 years ago

Solved

Power BI with Google BigQuery

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_0...

Tutorial Requests

v-ljerr-msft
9 years ago
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? :smileyhappy:

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

Regards

Community Champion

9 years ago

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