Forum Discussion

CAJMM1's avatar
CAJMM1
Regular Visitor
6 years ago
Solved

Anexar tablas

Buenas tardes:   Estoy preparando un informe que extrae datos de tablas con más de 600.000 filas cada una y son varias (4 o 5 tablas de 80 - 90 megas cada una)   ¿Es mejor conectar power BI a las...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi CAJMM1 ,

     

    If the five tables have similar data construction, we suggest to  combine them into one table so that it will be more easy to calculate result in report. But if they  different data table, it will be better to import them separately and create relationship between each other。


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi CAJMM1 ,

 

If the five tables have similar data construction, we suggest to  combine them into one table so that it will be more easy to calculate result in report. But if they  different data table, it will be better to import them separately and create relationship between each other。


Best regards,

 

CAJMM1's avatar
CAJMM1
Regular Visitor
6 years ago

Five tables have the same estructure, so I will follow your suggest, I will combine them.

 

Thank you very much.

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi CAJMM1 ,

     

    We can use the "append as new query" in the Power Query Editor, or just write a query using Table.Combine function as following:

     

    let
  Source1 = ..... ,
  Source2 = ..... ,
  Source3 = ..... ,
  Source4 = ..... ,
  Source5 = ..... ,
  NewTable = Table.Combine({Source1,Source2,Source3,Source4,Source5})
in
  New Table


    Best regards,