Any one with any thoughts?
Problem is due to a common field which is needed for blend the data from secondary data source. Without any common key this is not possible. Yes with some custom SQL may be it will work. May be someone from community will help you regarding this.
Data blending is done when you blend data from multiple data sources on a single worksheet. The data is joined on common dimensions.