Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |