Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
With the Composite Models Preview feature enabled, we have connected to our data source with DirectQuery and generated a date table. However, when trying to create a relationship between the date table and a data source table, it is being analyzed as many to many. We double checked the date table and it was generated correctly (no repeating dates).
When trying to manually change the Cardinality, there is an error "The cardinality you selected isn't valid with this relationship." and will not allow the cardinality to be set.
We have recreated this issue in a separate Power BI instance connecting to a separate data source with the same outcome.
With this being a preview feature, is it possible that this is simply a bug?
Appreciate the help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.