Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unable to open document with desktop optimized for report server

Hello all,   I've been working with the PowerBi desktop (normal yellow version) for a year and used to upload the model on the report server. Now that we move the report server to the january 2020...
support reportserver
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Yes, many-to-many is not supported in Report Server.
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Yes, many-to-many is not supported in Report Server.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I do confirm that many to many was the problem.

     

    Here is what I did:

    - Replaced all many to many by one to many relationships. Unique ID created if requested.

    - Replaced all "both" relationships by "single"

    - Replaced all calculated columns in fact table by measures.

    My model dropped from 400Mo to 150Mo and the loading time dropped from 30secondes to 14secondes.

    Thanks!