May 2024 Update - Issues with Manage Relationships and Sort By Column

[MaineGuy1993]

I updated recently to the May 2024 version.  After installing, I had problems with both Manage Relationships and Sort By Column.  When trying to Manage Relationships, Power BI threw a message:

"Cannot perform interop call to: MinervaDialogHost_modelingServiceHostService.ExecuteDataQueries......"

Likewise, when trying to use the Sort By Column under Column Tools, Power BI threw a message:

"Cannot perform interop call to: exploreClientInteropHost_modelingServiceHostService.ExecuteDataQueries......"

To fix both issues, I have reverted back to March 2024 version and the above functionality works fine.  I work on a Windows Server 2019 with much free space.  

Any help would be appreciated.  

[v-xiaoyan-msft]

Hi @MaineGuy1993 ,

Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

Best regards.
Community Support Team_Caitlyn

[MaineGuy1993]

Hello,

I have reverted back to the March 2024 version, therefore I no longer have the detailed May 2024 version information.    However, I updated from the MS site on Saturday, June 1st the 64 bit version onto my Windows Server 2019 Version 1809 (OS Build 17763.5696).  

Below is the full error message received when trying to create a relationship between two tables.  After reverting back to the March 2024 version, this relationship caused no problems.  Also, please note that I used the Model View icon to manage my relationships.  When I used the Manage Relationships icon under the Modeling ribbon, it was unable to show any fields in the tables where I wanted to create a relationship.  In fact, any table I chose it was unable to show any fields.  

Below is the full error message I received when trying to use the Sort by Column functionality under the Column Toos.  Again, after reverting back to March 2024 version, this caused no problems.  This is a simple sort where Monday = 1, Tuesday = 2, Wednesday = 3, etc...:

These issues are not specific to one Power BI.  I have approximately 25 different Power BIs with over 250 different reports.  I tried in several different Power BIs and received the same error messages.  Interestingly, none of my previous relationships or previous column sorts are impacted.  They appear to all be working.  I just can't create new relationships or column sorts.  

I realize this is really two different issues.  But both issues are due to my update to the May 2024 version.

Thank you for your help  

[ellenzhu5]

Hi,

I have the same issue with manage relationship, there is no 'OK' to click.... I have the same version, Version: 2.129.1229.0 64-bit (May 2024),

Please resolve this Issue, thanks,

Ellen

[Chally92]

Hi,

I'm having the same issue too in the same two situations - manage relationships and sort by column. Are there any known interim solutions other than a roll-back to the March 2024 version?

Regards,

Charlie

[MaineGuy1993]

Hi All,

Since I have received no further information from MS, I have reverted to using my laptop to develop instead of on the Server.  I do not have the same issue on my laptop, but I have other downsides.  It takes much longer to load a PBI from the Server and it takes much longer to save to the Server.  It is frustrating and I really don't like workarounds, but at least I can work.  I am also able to update to the latest version of PBI Desktop.  I don't need to work with the March version as my latest version.  However, again, this creates an issue.  I need to ask my IT department to install the lastest version of PBI when one comes out.  I don't have the necessary rights to do my own installs.  😞

[ruchita_manuja]

Any updates on this issue? I have been having this issue on PBI Desktop from the last 3 releases too. Our  Admin team recently rolled out verison Version: 2.132.1053.0 64-bit (August 2024) and I am having this issue with this new version too.