Power Platform Community Forum Thread Details

Problem appending two dataverse tables

I am trying to append two dataverse tables which I created as a test (test table1 and test table2) and added one column (person) to both tables with some information (everything else equal). I would like the test table1 information to be on top and then test table2 information on bottom and then create a third table where this information would be listed. I use the dataflow and power query editor, but when I try to choose "Combine" and "Append queries" it takes forever to load and results in the following error:

---------- Message ----------
We're sorry, an error occurred during evaluation.

---------- Session ID ----------
f8816cd7-19f7-40c9-9b5f-be7d4f933959

---------- Request ID ----------
65c5ee9f-5481-49f2-a094-0037bdb875c3

---------- Mashup script ----------
section Section1;
shared cr7a7_testtable1 = let
Source = CommonDataService.Database("org9c765cbd.crm4.dynamics.com"),
#"Navigation 1" = Source{[Schema = "dbo", Item = "cr7a7_testtable1"]}[Data],
#"Appended query" = Table.Combine({#"Navigation 1", cr7a7_testtable2})
in
#"Appended query";
shared cr7a7_testtable2 = let
Source = CommonDataService.Database("org9c765cbd.crm4.dynamics.com"),
#"Navigation 1" = Source{[Schema = "dbo", Item = "cr7a7_testtable2"]}[Data]
in
#"Navigation 1";