Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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?
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.
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)
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:
I am having this same issue. Has anyone identified a resolution? File cannot even be opened.
I'm too having the same issue. There are lots of tables involved. Someone, please help.
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.