Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
benjomeyer
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
Community Champion
Community Champion

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)

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.

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.