Importing Sharepoint Excel doesn't show blank values in a one-to-many relationship

[Anonymous]

I have a sharepoint spreadsheet which allows people to update their team names and team members and it'll then refresh in Power BI. Previously, it was a spreadsheet that was manually updated by myself and then uploaded to a SQL database that did the exact same thing with the main difference being me being fed the team names and members and adding it myself compared to all the managers adding it themselves. 

With the SQL database, it would show (Blank) in the team if there was missing rows of data for the one to many relationship. This would show in both the slicer and any visuals with Team in the fields list (legend, etc.)

In Sharepoint, it doesn't show the (Blank) team if there was missing rows of data. 

Two issues here: 

1. I'm unable to see whether there is someone missing in the teams / consultants if it does not show me the blank team. This helps because if I have a (Blank) row, it tells me who else I need to add to the Sharepoint list. 

2. Even though (Blank) is not showing up, it is still summing it up in the grand total of the matrix / table visual. 

Has anyone ever encountered this? I've looked around this forum and most people are asking how to remove the (Blanks) while I want the (Blanks) to appear! 

An example of this below: (Numbers aren't adding up because the SQL spreadsheet has not been updated as we have been using the Sharepoint dataset) - but focusing on the blanks - we are not reporting a considerable amount of rows from the dataset if the blanks aren't showing.  

Sharepoint: 

SQL: 

Otherwise, please let me know if there's another way around this - our team does not want to be ones updating this spreadsheet/reference table as these teams have people leave and join most days of the week. 

[lbendlin]

this needs a few more details.  which side of the relationship did you take the fields from? Have you enabled "show items with no data" ?