Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.