cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
benjomeyer Frequent Visitor
Frequent Visitor

Append tables reduces the number of rows unintentionally

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?

3 REPLIES 3
MarcelBeug Super Contributor
Super Contributor

Re: Append tables reduces the number of rows unintentionally

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?

Specializing in Power Query Formula Language (M)
benjomeyer Frequent Visitor
Frequent Visitor

Re: Append tables reduces the number of rows unintentionally

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 Super Contributor
Super Contributor

Re: Append tables reduces the number of rows unintentionally

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

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors