Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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?  

 

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.