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

[akemr]

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.

[Dravidan]

Hi, I am also facing the same issue. Could you elaborate what you have did and how you fix the problem.

Thanks

[akemr]

Hi Tex628 and Amitchandak,

Thank you for the replies, fortunately for some reason once i went to Transform data and reviewed the actions that i had taken earlier and refreshed one more time, row #49 was shown again. I am not sure what i did differently if anything at all, but the issue seems to have been fixed now. I'm still really confused about it but for the time being this issue is resolved I guess.

Thank you for your help 🙂

[tex628]

I'm glad it worked out. Let me know if there are any other issues! 🙂 

/ J

[amitchandak]

@akemr , do you have country dimension created? if so check with and without using dimension the difference

[tex628]

Sounds like there is something wrong in the excel file. Try copying the entire table and paste values to another page in the excel file to see if there is any issues related to the formatting. 

You should also check if the row is present in power query, I don't know if you are doing any transformations there that could affect the outcome of the load. 

Br,
J