Reputation: 232
Cannot establish many to many relationship in my model
I am using PowerBI Desktop September 2019 release and I have two tables :
Employee Country I want to establish Many to many relationship between the two tables but I can't find (it is not detected) :
When I want to desactivate Composite Model in the features, I can't find the Preview features in GLOBAL :
Upvotes: 0
Views: 840
Answers (2)
Reputation: 1
I think in your case, you are deploying to a Power BI Report Server instead of to Powerbi Desktop.
Power BI Report Server does not support many to many relationships yet, that is currently only supported in the cloud environment.
You can know the difference by checking this article.
Upvotes: 1
Reputation: 51
are you using the Power BI Desktop Report Server? as the preview features wouldnt be available in there
If you could show more information about your tables that would be helpful
Upvotes: 1
Related Questions
- How to create 2 active relationship between 2 tables
- Get "not allowed for columns on the one side of a many-to-one relationship" errors
- Can't determine relationships between the fields
- How to make power bi work with many to many?
- Cannot create a 1:M relationship
- PowerBI Relationship
- 1 to many relationship involving multiple fields in power bi
- Problem creating unique values to create a relationship in Power BI
- How to create a many-many relationship in Excel's data model?
- BI Designer many to many relationship