Composite Model of web - "google spreadsheet" and directquery - "SQL Server"

[Anonymous]

Hi All, 

I need to use the composite model in power bi. for example, I can show the "Date" (directquery); as a primary file vs the region from google spreadsheet in power bi desktop; with the sreenshot.

But when I publish to the power bi app/ web, the date column is missing with the screenshot attached:

may I know is there any solution for this?