Append tables reduces the number of rows unintentionally

[benjomeyer]

I am trying to append 4 tables. 3 have 1000 rows each and the 4th has 31 rows. When I append the first 3 tables, I get 3000 rows as expected. But when I then append all 4 tables, I get 331 tables - i.e. only 100 from each of the first 3 tables.

Any ideas what's happening here?

[MarcelBeug]

Usually you would get all rows, so there must be something specific.

We need more information from your side to figure out what is going wrong.

For instance:

How did you append the tables: in DAX or in Power Query?

Where do you get only 331 rows: in Power Query or in the data model or in some visual?

How do you know that it is 3x100 rows + 31 and not e.g. 2 x 50 + 1 x 200 + 31?

[benjomeyer]

Hi,

My initial queries to populate these tables were rest queries from JIRA. It turns out that this issue has nothing to do with PowerBI and is a recent bug with JIRA:

https://jira.atlassian.com/browse/JRACLOUD-67570?_ga=2.74378642.1264392191.1505907822-1306179738.148...

Thanks.

[MarcelBeug]

Thanks for your feedback, well appreciated   (I'd wish everybody would be so kind...).