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".
Hi zimmermanaric,
What do you mean by having different values for periods past that are closed?
How are you appending the tables and how are you calculating the result for the months that are closed?
Regards,
MFelix
Hi! I am pulling the data into Power BI via Sql. There are only a few columns:
1. period
2. year
3. amount
The where clause in the sql statement is limiting it to year 2017 and higher. Then I am using the "Append as New" function in the Advanced Editor. Once done, I create a simple matrix table showing the value as amount, column as year and row as period. Each time I refresh, I get a different answer. The only account period that we have open is Feburary 2018. Prior Month's should be the same. This is only happening with a table that is appended from the 4 other tables. If I do the same matrix with each individual table, the numbers to not change on each refresh of the data.
Hi zimmermanaric,
Sorry for the question but Why are you making new appends with several SQL and not a single SQL for everydata?
could it be possible that you are repeating data everytime you add a new query?
Regards,
MFelix
I really appreciate your thoughts! It is 4 sql statements that are written the same way, pulling the same columns and years, but connected to 4 differnent databases.
Did you figure out why this is happening? I'm having the same issue.
I have two queries being appended into one. Each time I refresh the values from the appended table change, even though the values in the original two queries stays the same.
