Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
Could you do an Append query? Perhaps I am not understanding what you are going for though.