Need help in blending or joining two different data source

I have 2 data sources one Google sheet and one sql table so I need to compare both data so I need to either join or blend the data but when I blend the data using the common column in both data sources I am not getting the count correctly and if I join i have no issue in the data part but when i publish in the tableau cloud i am getting an error unsupported file