Forum Discussion

Jorgast's avatar
Jorgast
Resolver II
5 years ago

New Append Query

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 2...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Jorgast
    Resolver II
    5 years ago

    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?