Missing Data from the Linked Excel file

Hi Everyone,
Am having issues with missing data from the Excel file I connected to my Kobo database. When I export an xls file directly from Kobo, I see the data in those specific rows but when I open the linked excel file those rows are blank.
See screen shots
Linked File

Welcome to the community, @aomitta! It seems like you are trying to use the Excel Power Query to link your data to Excel directly from the server.

Yes I am, I need to run pivot tables and charts from excel but some of the data isn’t showing. How best can I make use of Excel to show all the data. (My form has 1 repeat group with all the data I need).