Forum Discussion

MartinFM's avatar
MartinFM
Helper I
1 year ago

Models not supported in Power BI Report Server

Hello,

 

I get the following error when I try to open one of our reports:

"This file uses many-to-many relationships or a composite model which combines DirectQuery sources and/or imported data. These models aren't currently support in Power BI Report Server".

 

However the report was created on the exact Power BI Desktop version that matches the server version (January 2021) and the report is currently running on the local server. Sooooooo...

 

I know, it is an old server and desktop version and the solution is most likely to upgrade to more recent versions where this issue might have been fixed. I just wanted to add the information to the forum so that if anyone else encounters this problem, they know they are not alone 🙂

9 Replies

  • Are you using the version of Desktop that is specifically targetted at Report Server? Does the app icon have an "RS" on it? 

    If you use this version of desktop it should not let you create reports that are not supported by the server.

    • MartinFM's avatar
      MartinFM
      Helper I

      Hello,

      Yes, I use the Power BI Desktop version targetted at Report Server (as I already stated).

      Yes, the icon has "RS" on it.

      It was purely an informational statement. As I already noted this is probably just a bug in the old versions and the solution is most likely to upgrade to a more recent version where this problem does not exist.

      • d_gosbell's avatar
        d_gosbell
        Super User

        MartinFM wrote:

        Yes, I use the Power BI Desktop version targetted at Report Server (as I already stated).


        Well you actually said that you use the version that "matched" it was not clear if this was the version targetted at Report Server or just the cloud version of desktop from the same month. (this is a common mistake people make which is why I was clarifying this)