New Append Query

[Jorgast]

Hello Power BI community

I have 2 salesforce queries. Each of them is gathering the same 15 fields from salesforce. The first query pulls in all of 2020 data and the 2nd query is pulling in all of 2021 data. Both queries are the same except for the date range. Once my 2020 query pulled in the data, I turned off the “Include in refresh” option.

I created a New append query to bring in the 2020 and 2021 data into 1 table. I have recently refreshed the 2021 data and the append query data, but my table is only showing me data from Feb 2020 to Mar 2021, when I expected to see Jan 2020 to Mar 2021. I went back to look at the original 2020 table and I do see data from 1/1/2020 12:00:02 to 12/31/2020.  I have even tried to create another append query and reverse to order of the tables being appended but I am getting the same results. I do not have any report-level date filters and my separate date table goes back 3 years.

Is there a limitation to the append query?

4,673,000 rows—2020 Salesforce data

1,192,000 rows –2021 Salesforce data

[amitchandak]

@Jorgast , This not very usual that append query miss any data, check for any error, the column might have been highlighted with red. Check data types are the same or not?

Also, check data on the visual, table sometimes does not load the list of values properly. and power query does not show all data.

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[Jorgast]

@amitchandak 

• Field types are all the same
• No error in Power Query
• In the Power Query Preview Append table, I added a sort by date in ASC and got the same results
• When I look at the Append table in the Data tab I only see Feb 2020 to Mar 2021

In the Power Query Preview, I added a sort-by date in ASC for the 2020 data and the data starts on 2/1/2020. Yet I have turned off the “Include in Refresh”, so this should be showing 1/1/2020 data. I do know that the data source only contains historical 14 months of data. So this would mean that the 2020 data is still refreshing even when I did not want it to. Would the “Enable load” in the Power Query preview have anything to do with it?