Forum Discussion

Zzema's avatar
Zzema
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_02 and so on.

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

Need Help
Tutorial Requests
  • v-ljerr-msft's avatar
    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

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

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