Date table in Direct query

Hi Anonymous 

Please kindly refer to the official document for more details of Mixed mode:

https://docs.microsoft.com/en-us/power-bi/desktop-storage-mode 

https://docs.microsoft.com/en-us/power-bi/desktop-composite-models 

Composite models have some security implications. A query sent to one data source can include data values that have been retrieved from another source. 

Consequently, information that's stored in the spreadsheet is now included in a query that's sent to the relational database. If this information is confidential, you should consider the security implications. In particular, consider the following points:

• Any administrator of the database who can view traces or audit logs could view this information, even without permissions to the data in its original source. In this example, the administrator would need permissions to the Excel file.

• The encryption settings for each source should be considered. You want to avoid retrieving information from one source by an encrypted connection and then inadvertently including it in a query that's sent to another source by an unencrypted connection.

Or is there any alternative to create a date table in direct query.

That is currently not possible. You should try and create date table in your source to make it accessible in Direct Query Mode.