Adding Column From Source

[leahschneider]

I need to add a column 'type' in the SQL query that my Power BI report uses.  I add it in SQL and refresh the query.  This causes me to get the error of "Failed to save modifications to the server.  Error returned: 'A table of multiple values was supplied where a single value was expected.  The current operation was cancelled because another operation in the transaction failed.'

I know that adding this column will cause some of my custom columns to not work anymore because of the multiple values mentioned above.  But it seems like it would be impossible to fix this if I can't add the column to begin with.  I'd rather not start this entire project over and I need this column added. 

[leahschneider · Accepted solution]

If anybody else is interested, I solved it.  I put the column as blank in the SQL which wouldn't cause errors and then fixed each Power BI column it occurred in.  It was fairly trial and error.  I wouldn't reccomend it. If anybody has a better solution or if Power BI wants to help with some easier error message or at least let me load tables with bad columns, that would be neat.

[Sean]

@leahschneider

You can try the opposite of what I suggested here - instead of delete - add the column!

http://community.powerbi.com/t5/Desktop/Referesh-Error/m-p/126055#M53424

Hope this works.

Good Luck!

[leahschneider]

The column adds in query editor.  It just won't let me apply the change to the report because of the multiple values in a single table errors.  The error is not in the refresh preview, it is in the close and apply.