Forum Discussion
Merge Tables Power Query in Direct Query
Hi JohnnyT48 - When utilizing the "Enter Data" option in Power BI, there is a 3,000-cell limit that you must adhere to.
Instead of merging the tables in Power Query, you can use DAX to combine the tables within Power BI. This approach avoids the 3,000-cell limit imposed by the "Enter Data" feature.
CombinedTable =
UNION(
SELECTCOLUMNS('Table1', "Column1", 'Table1'[Column1], "Column2", 'Table1'[Column2]),
SELECTCOLUMNS('Table2', "Column1", 'Table2'[Column1], "Column2", 'Table2'[Column2])
)or you can also check by choosing the smaller datasets as like
Table1: 1000 rows
Table2: 1000 rows
Table3: 200 rows
Append in Power Query:Append Table1 and Table2.
Append the result with Table3.If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much just tested and it is working, appreciate your help.
Thank you
Hi JohnnyT48 - When utilizing the "Enter Data" option in Power BI, there is a 3,000-cell limit that you must adhere to.
Instead of merging the tables in Power Query, you can use DAX to combine the tables within Power BI. This approach avoids the 3,000-cell limit imposed by the "Enter Data" feature.
CombinedTable =
UNION(
SELECTCOLUMNS('Table1', "Column1", 'Table1'[Column1], "Column2", 'Table1'[Column2]),
SELECTCOLUMNS('Table2', "Column1", 'Table2'[Column1], "Column2", 'Table2'[Column2])
)
or you can also check by choosing the smaller datasets as like
Table1: 1000 rows
Table2: 1000 rows
Table3: 200 rows
Append in Power Query:
Append Table1 and Table2.
Append the result with Table3.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much just tested and it is working, appreciate your help.
Thank you