Single Row of Data from Source Teams Excel File doesn't show up in the Local PBID Dataset

Hi all,

Would appreciate any help. 

So my source file is on a Teams folder. I opened the folder in Sharepoint and used the Sharepoint connector to access the folder and then the file, and everything was imported correctly. I've made a dashboard and published it to my Teams folder as well and it works perfectly fine.

The content of the file is around 67 contracts, located in different countries. The country is a filter for the items.

My issue is that when I insert a Card on the dashboard for the Count of the Country column, it does indeed show 67. However, When I add the Country field as a parameter and insert a multi-row card, it shows (Blanks) as one of the countries. 

Upon further investigation, I found out that an Algerian contract does not show up in the local dataset at all. Its row #49, but in the local dataset (which is directly linked to the Teams Excel file), it only shows #48 and #50. 

I tried refreshing the local dataset, refreshing the report, but nothing works. When I make changes to any other row in the source file, that change reflects correctly after refreshing. But for some reason, #49 doesn't show up at all. 

Any suggestions as to what I should try? Thanks a ton.