We are having issues using the "Append Queries" feature. Specifically "Append Queries as New". We have 4 seperate data sources all with the exact same headers, Date, Location #, and Total GL Balance for a group of accounts. All four data sources are on seperate servers. When we load into BI and Append the 4 queries into 1 table we notice data goes missing. What is even more odd each time the data is refreshed different rows of data seem to be missing each time. This can be demonstrated by making 2 seperate "Append Queries as New" unique tables and comparing them. Even though they are combing the same 4 tables they both are different. Total rows of data is under 800,000 combined, and there are no duplicate rows from the 4 queries.
Has anyone else been experiencing this problem with the Append Queries feature?
Does Microsoft have a solution for this problem?
tks
v-xiaoyan-msft
on:
Cannot share PowerBi reorts and dashboards to my o...