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

Re: Values Change in Append

I am very sorry. In my haste I misread your post. I thought you said that you removed your order by. I will try it and let you know.

khappersett Member
Member

Re: Values Change in Append

@zimmermanaric

 

No worries! Hope it works for you .

zimmermanaric Regular Visitor
Regular Visitor

Re: Values Change in Append

That reduced the magnitude of the change in the number, but it will isn't adding up correctly and changes every time I hit refresh.

 

khappersett Member
Member

Re: Values Change in Append

Hmm did you add it to all 4 queries you’re appending?
zimmermanaric Regular Visitor
Regular Visitor

Re: Values Change in Append

Yes. I added the same order by to all 4 queries. How many columns are you selecting in yours? Did you order by all of them?

 

 

khappersett Member
Member

Re: Values Change in Append

I just ordered by one column. Not really sure why it worked for me - sorry you didn’t have the same luck
Super User III
Super User III

Re: Values Change in Append

Hi @zimmermanaric,

 

First of all let me apologize for not responding on this message but add some issues witht work, and also lost the track to the treadhs I had open on my Inbox.

 

Can you please give some more details on your setup? To my experience when I add several SQL in PBI the only issues I experienced similar was when people where inserting data in the database so every time I refresh during my tests the data was changing.

 

Regards,

MFelix 


Regards

Miguel Felix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




zimmermanaric Regular Visitor
Regular Visitor

Re: Values Change in Append

Hi! Inserting records is not the issue here. I am querying information in the past that should not be changing.

 

 

Ofir Frequent Visitor
Frequent Visitor

Re: Values Change in Append

I'm with the same problem. Is there anything new about this?
dgbraqe Frequent Visitor
Frequent Visitor

Re: Values Change in Append

Hello,
Did you open a ticket at Microsoft? Got any returns? I'm having the same problem, using the "append as new" option, the new table is different from the original tables.

Helpful resources

Announcements
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