Failed to save modifications to the server. Error returned: 'There's not enough memory to complete..

[Anonymous]

Our DBA did a database migration over the weekend, so I had to go to query editor to update just the Server name for a PowerBI report. Everything else stayed the same.

Anyway, when I ran the query in SSMS, it returned in a couple of seconds; but, when I ran it in PowerBI, it loaded up in the query editor, but once I tried to 'Apply Changes', I got an error: Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation'. Essentially, I created this report several months ago, but once I need to update it after server changed, something in the process broke.

[Anonymous]

This has happened to me twice on two different reports. The reason is because I used the 'Index Column' feature in Power Query Editor. Once I deleted the applied step for that, I was able to successfully apply the changes and load the data in without an error. Also, my scheduled referesh on the server began working again. So, if Googling or Binging the error in quotations above brought you here, check to see if you have used the 'Index Column' feature in Power Query Editor and try deleting it if you also have this error.