Forum Discussion

xieysie's avatar
xieysie
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Table.Combine takes forever

I want to combine four tables into one using Table.Combine({#"MDSConfig (Monitoring)", #"MDSConfig (Weve)", #"MDSConfig (Auth)", #"MDSConfig (Cafe)"}), but it never ends when refreshing data. There are only hundreds of columns in the tables to combine which comes from Kusto.

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago
    There are only hundreds of columns in the tables

     

    Good one.  Which of these hundreds of columns do you actually need?  How different is the column structure between these tables?  Have you considered doing table joins instead, or combining the tables in DAX?