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. T...
power bi server
MartinFM's avatar
MartinFM
Helper 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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, MartinFM 

In addition to the one above, your report may use a many-to-many relationship. In the changelog, many-to-many relationship reports are supported starting in January 2024.

Change log for Power BI Report Server - Power BI | Microsoft Learn

You can open it with the standard version and check the model relationships inside:

 

 

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.