*:* gets displayed as *:1?

ovonemty 51 Reputation points
2021-09-13T14:27:20.423+00:00

Is this a bug? I have a MANY:MANY relationship

131596-image.png

I press ok, and it appears displayed as Many to one?
131622-image.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-09-14T02:32:51.017+00:00

    Hi @ovonemty ,

    What is the compatibility level? Tabular models at the 1500 and higher compatibility level deployed to Azure Analysis Services, SQL Server 2019 Analysis Services, and Power BI Premium support many-to-many relationships. Tabular models at the 1400 and lower compatibility levels do not support many-to-many relationships, and you cannot add junction tables in the model designer. However, you can use DAX functions to model many-to-many relationships. For more information, please refer to Many-to-many relationships.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Docs 15,146 Reputation points
    2021-09-20T07:34:21.03+00:00

    Is the problem that you are having similar to the problem in this feedback:

    https://learn.microsoft.com/en-us/answers/idea/541983/posts-fail-to-display-in-case-it-could-not-be-seen.html

    If yes, then please add your comments and vote.

    .
    .
    .
    .
    .
    Please remember to vote and to mark the replies as answers if they help.

    On the bottom of each post there is:

    Propose as answer = answered the question

    On the left side of each post: Vote = a helpful post
    .
    .
    .
    .
    .

    0 comments