cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
swise001 Regular Visitor
Regular Visitor

MERGE is TRUNCATING data table - which then fluctuates after EVERY refresh (using static tables)

I've noticed this behavior with one of my Power BI Desktop files.  After every refresh (immeidate back-to-back-to-back refreshes), the imported row count varies wildly (randomly going up or down - and seemingly truncating the static source data.

 

To diagnose the problem I imported all of the table into the model (with no relationships) - and used a COUNTROW to identify the count of each table.  Upon refresh - the source tables all remain constant.  However, the table where MERGES are used varies wildly. 

 

Then I took the table with merges and duplicated it 5 times (1 instance after every merge).  I found the the changes occured at every instance of a merge.  These merges are left joins (and again none of the source tables are changing size).  

 

Any one have an idea of why the merges might be truncating the table data?  These are simple left joins (default merge in Power BI).  I've never experienced this before and even built the report back up from scratch - only to see the behavior continue. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
swise001 Regular Visitor
Regular Visitor

Re: MERGE is TRUNCATING data table - which then fluctuates after EVERY refresh (using static tables)

Update - after further investigation - it seems to be caused when I merge against a View Table from SQL.  The same issue does not occur when I merge using a standard table (even though both tables are not changing). 

View solution in original post

2 REPLIES 2
swise001 Regular Visitor
Regular Visitor

Re: MERGE is TRUNCATING data table - which then fluctuates after EVERY refresh (using static tables)

Update - after further investigation - it seems to be caused when I merge against a View Table from SQL.  The same issue does not occur when I merge using a standard table (even though both tables are not changing). 

View solution in original post

Community Support Team
Community Support Team

Re: MERGE is TRUNCATING data table - which then fluctuates after EVERY refresh (using static tables)

@swise001,

 

Thanks for sharing this. You may help accept solution. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

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