Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Many to many cardinality causing issue to open PBIX in Power Bi reporting Server

I have a PBIX whose data set has many to many relationship within the tables. I have created it in normal power BI desktop app. When I am trying to open the same PBIX on Power BI desktop for reporting server , I am getting an error : "This file uses many to many relationships or a composite model which combines DirectQuery sources and/or imported data. These models arent currently supported in Power BI Report Server". Please help.POerBI RS issue.JPG

 

13 REPLIES 13
riskybell
New Member

Same issue here with a bunch of reports.  I'm paying $5k a month for my seat license and it doesn't support a simple join? 

robinwilson16
Frequent Visitor

Same issue for me in the May 2021 release.

How do we stop this happening. Surely it can't still be a preview feature 2 years later?

It is not a preview feature, since they do not intend do release it. 

Solved: Re: Does Report Server support Many to Many relati... - Microsoft Power BI Community

Use the "table bridge" to solve this.

https://community.powerbi.com/t5/Desktop/Bridge-table/m-p/219805

 

 

Hello

 

Thanks for the reply but upgrading Power BI Server to the latest version initially works but then if the correct version of Power BI Desktop is used the report is migrated to the new version and initially works but after I close it I cannot edit it a second time and get the error but can open the original RDL and repeat the process with the same result.

 

We had to revert the Power BI Server back to the earlier version and are unable to upgrade it as with about 20 reports it would mean all of them would need to be recreated. The next problem is that Microsoft does not make the older versions of Power BI Desktop available and that had been upgraded so I had to find this from a 3rd party location (even Chocolately says it is installing the version I need but just goes and installs the latest one so must also have a bug!).

 

I got everything working again in the end but still upgrading Power BI Server to the latest version breaks all reports when everything is fine without applying upgades but means we cannot take advantage of any new features and need to ensure we keep the desktop installer somewhere safe.

I faced similar problem here. The only solution was to recreate  all the PBIXs without many-to-many relationships. In order to do it, you use "bridge tables":

https://community.powerbi.com/t5/Desktop/Bridge-table/m-p/219805

 

After doing it, you can upgrade the server.

atuljha
Regular Visitor

The problem i am facing is a dashboard was designed in an older version of PBI Desktop, and uploaded to the PBI servers. The Desktop and Servers were upgraded to a newer version.

now that i have to make an edit to the PBIX, i am getting this error. So whats weird is, the "older PBI Desktop" supported the feature, but the newer one does not.

 

Even if i consider rebuilding the dashboard (which was easy) the datamodel itself was complex, and had embedded SQL in it, which i dont have access to.

 

Anybody here was able to get access to the info from any other source (like with SSRS RDL, you could crack open the RDL in Notepad to get details)

Jrussi1301
Frequent Visitor

Use the normal Power BI Desktop version, and upload the .PBIX file directly at the web portal of the Power BI server. Pay attention to the release, it must match your Power BI Server. For example, for Power BI Server january/2020, use Power BI Desktop december/2019 or below.

 

I think the deal with Power BI Desktop RS is that it does not support preview features. It seens to me that many to many cardinality on Power BI Server is a preview feature for now. 

 

Please refer to:

 

https://github.com/MicrosoftDocs/powerbi-docs/issues/2294

KaufmanNat
New Member

I am having this same issue. Has anyone identified a resolution? File cannot even be opened.

Anonymous
Not applicable

I'm too having the same issue. There are lots of tables involved. Someone, please help.

rwyoung01
Frequent Visitor

Does anyone have an answer for this.  My report server is on Jan 2020 and still can't upload my pbix

Create a table in between that holds single combination of the keys coming from the two tables. then join this new table against each outer table.  

Anonymous
Not applicable

@mpsrshl  can you please show us an example, it'll be really helpful.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors