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

Failed to save modifications to the server. Error returned: 'The expression refers to multiple colum

Hi All,

 

when I have upgraded version of Power bI Desktop I found out that one of my report does not open anymore with the following description:

 

Error Message:

Failed to save modifications to the server. Error returned: 'The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Memory error: Memory Allocation failure : Not enough storage is available to process this command. . Try simplifying or reducing the number of queries.

 

and etc.

 

Does anybody have any variant how to cope with that?

Thank you for the response!

1 ACCEPTED SOLUTION

Hi NastyaLagunova,

 

Please download PBI Desktop from here: https://powerbi.microsoft.com/en-us/downloads/ and check if the issue still occurs.

 

Regards,

Jimmy Tao

View solution in original post

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

Hi NastyaLagunova,

 

What had you done when the issue occured? Were you trying to refresh your report or import some other data source to your report with SQL statements? Could you please provide more details about your issue?

 

In addtion, about the memory error, I would recommend you to use 64-bit version power bi desktop instead 32-bit because there's no memory limitation in 64-bit version.

 

Regards,

Jimmy Tao 

Anonymous
Not applicable

Hi Jimmy!

 

Thank you for the response.

I have downloaded new version of Power BI here: https://www.microsoft.com/en-us/download/confirmation.aspx?id=45331 (as soon as you hit the page, it automatically offers download). Afterwards when I updated my bersion of Power BI on the existed one, I see this error while openining workbook. 

'Were you trying to refresh your report or import some other data source to your report with SQL statements' - no, I did not do anything like that.

 

Where I can download 64 bit version?

 

Sincerely,

Anastasiia Lagunova

Hi NastyaLagunova,

 

Please download PBI Desktop from here: https://powerbi.microsoft.com/en-us/downloads/ and check if the issue still occurs.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

Hi Jimmy,

 

thank you for the link. Yep, it works fine! Report opens as usual.

But for me it is interesting: which type of Power BI version people download here (https://www.microsoft.com/en-us/download/confirmation.aspx?id=45331), so that it doesn't work?

 

Best Regards,

Anastasiia Lagunova

 

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.