Forum Discussion
Values Change in Append
My apologies for the delay in response here. I was on vacation when you asked the question and the email was lost in my inbox until now. I did solve this purely by luck. It appears that if you have conflicting privacy levels (and sometimes even not) the append will give different results. I turned off the following option in my reports and things stablized:
File=> Options and Settings => Options=> Privacy
From there I chose the other radio button option "Ignore the Privacy Levels and potentially improve performance".
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.
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.
- Hmm did you add it to all 4 queries you’re appending?
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?
- I just ordered by one column. Not really sure why it worked for me - sorry you didn’t have the same luck
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
Hi! Inserting records is not the issue here. I am querying information in the past that should not be changing.
- I'm with the same problem. Is there anything new about this?
