Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.