Forum Discussion

MartinFM's avatar
MartinFM
Icon for Helper I rankHelper 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. T...
power bi server
MartinFM's avatar
MartinFM
Icon for Helper I rankHelper I
1 year ago

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
Icon for Super User rankSuper User
1 year ago
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)

  • MartinFM's avatar
    MartinFM
    Icon for Helper I rankHelper I
    1 year ago

    Ah, OK, thank you, I was not aware of this 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Your Solution is so great d_gosbell

      Hi, MartinFM 

      As Super User said, you're confusing the two versions. You encountered this error when you opened a report that Power BI desktop did not have with the RS version in the RS version of Power BI desktop.
      Your report contains a composite data source, which is an unsupported data source type in Power BI Report Server.

      This isn't a bug with Power BI report server. It's just that you opened a report that wasn't part of the RS version of Power BI desktop.

       

       

       

      Best Regards

      Jianpeng Li

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

       

       

      • MartinFM's avatar
        MartinFM
        Icon for Helper I rankHelper I
        1 year ago

        I am not confusing the two versions. I am absolutely clear about the two versions. In fact, I am not using the cloud version of Power BI Desktop so it should be pretty difficult to confuse them.

         

        Let me reiterate:

        I am using the Power BI Desktop version with RS on the icon that is targeted at the Report Server version (January 2021). So both server and Power BI Desktop client is version January 2021. 

        I have created the model in the mentioned Power BI Desktop version, I have deployed the report including the model to the report server, the report works fine and is running as we speak. When I try to open the report in Power BI Desktop (January 2021 version with the RS on the logo), I get an error that the client does not support the report anymore.

         

        Br, Martin