Power Query has fewer rows than power bi datamodel? #postgreSQL

Hello again,

I stripped my problem down to the (I think) smallest piece of data an M-code. I attach all necessary files in a ZIP-file. It woulld be so nice if someone with a running postgreSQL instance can reproduce my problem - and if you can: someone can tell me where to send a bug report to microsoft?

The file contains the following files:

1) createDatatype: This creates an enumeration datatype. I need to select this column to reporoduce the error.

2) the ddl of the table with the data

3) the insert statements (about 23.000 rows with just 3 Columns)

and for sure: the power bi file. You just have to change the database server and the database.

I found these obervations:

- If there is no index on the "id" column, the duplication does not happen

- The transformation "select columns" is necessary. Otherwise no duplication happens

- you need to select the enumeration column. Otherwise no duplication shappens.

- the sort is necessary. Otherwise no dulication happens

I think the reason is hidden behind

- query folding

- paging with using the index

- the enumeration

Thanks everybody for your support!

Holger

PS: I was not able to insert attachments to this post - I always get exceptions like "txt is not supported, pbix is not supported,...". So here is a dropbox link:

https://www.dropbox.com/scl/fi/klcq6rusf83pgu7wj6ku6/postgreSQL_RowDuplication.zip?rlkey=imu2dp8qxlcvvz0rlizw5gtof&dl=0