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

Data changes on using Append_two different datasources

Hi folks,

Recently I ran into this issue .

I have appended two different data sources.(HANA+Azure AS)

and observed that on appending  these two using UNION (tried append query option as well)data changes in visualization.

 

Append.PNG

 

 

 

 

I tried the solution given in below post but did not work.

https://community.powerbi.com/t5/Desktop/Values-Change-in-Append/m-p/448684#M207643

 

any help/suggestion would be appreciated.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Data changes on using Append_two different datasources

@DAX_Learner07 ,

 

Have you checked the feature "Append queries" in query editor?

Capture.PNG 

 

In addtion, you said the data change, could you please clarify more details?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DAX_Learner07 Regular Visitor
Regular Visitor

Re: Data changes on using Append_two different datasources

Hi @v-yuta-msft ,

 

"Append Query " option had some limitations before 4-5 months for specific data source   and storage mode .As we have appended Azure+HANA datasource in Import mode.So we used UNION option.But for testing purpose I tried "append Query" option as well,which yielded  the same result as attached.

 

 

tex628 Super Contributor
Super Contributor

Re: Data changes on using Append_two different datasources

Are there an [Amount] column in both tables before the append?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)