Problem appending two dataverse tables

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