Problem appending two dataverse tables

[Syndicate_Admin]

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";

[ToddChitt]

We used a DataVerse model, and yes, you CAN query it via the Power PI DataVerse connector, but that has limitations, particularly on the number of rows it will return.

Instead, we used OData with something like this:

let
         Source = OData.Feed(https://<My Project Name>.api.crm.dynamics.com/api/data/v9.2/<table name>?$top=100", null, [Implementation="2.0"])
in
         Source

(This query gets you 100 rows of the entire table. I did not enable load on it. I just needed the field names, which is NOT the logical names in DataVerse.)

From there, we decided on which columns we needed, built a query that listed those columns by name (just a simple text string):

"field1, field2..." (no "let" or "in" for this)

Then a third query that uses the field list like this:

let
       Source = OData.Feed(https://<My Project Name>.api.crm.dynamics.com/api/data/v9.2/<table name>?$select=" & #"Field List for said Table", null, [Implementation="2.0"])
in
       Source

For more OData options: Query options overview - OData | Microsoft Learn