I would union some stub records to the data source via custom sql with just the name field populated and all other fields null.
I did as you adviced. Created new data source and placed all values using Custom SQL. The thing is that the original set of data comes from stored procedure, so I am unable to join it with my CustomSQL (or at least i do not know how to do that). Tried to connect both sources with a relationship, but in this setup I am unable to use: Show Empty Rows option so Brian is still not there.