Mixed mode...cannot connect direct query table to imported sharepoint list table

[Anonymous]

Hello Community  -  I thought in mixed mode  (composite model) this scenario should work but it is not.   I am able to connect one of the direct query tables to my imported sharepoint list table.   However, if I try to also connect my direct query date table to a date on the Business Development table I get the error below.  

If we need to create multiple relationships between a direct query data set, and imported tables, how is that done?  

[v-jingzhang]

Hi @Anonymous 

Are these direct query tables from a Power BI dataset or an Analysis Services data source, or other data sources? It seems you are using the preview feature (DirectQuery for Power BI datasets and Azure Analysis Services), does Date Table already have a relationship with FL_Customers_Query table in its original model? If there is already a relationship between two tables, it is not supported to create another active relationship between them. Additionally, see if you hit some limitations of this preview feature: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.