Not able to create a column.

[CLANG10]

Hi,

  Current i am getting a live connection datasource through Azure Analysis service and building a report in PBI desktop. But i don't have the option of adding a new column to build my report. Is this due to the datasource setting? Need advise on how to resolve this. Thanks!! 

[lbendlin · Accepted solution]

correct. You can only add columns in Import Mode or in Mixed Mode (Direct Query with local data model). Not for Live connection.

[CLANG10]

Thanks, i had configured the live connection to a direct query with local data model. It allows me to create calculated columns. No issue when creating 1 calculated column, but i have problems after creating 2 or more calculated columns, it gives the error: "The column cannot be pushed to the remote data source and cannot be used in this scenario".  I tried to troubleshoot by deleting 1st calculated column and leaving 2nd calculated column and vice versa. It fails to work when i have more than 1 calculated column. Any advise on what could be the possible issue?

[lbendlin]

Interesting error message. Usually the limitation only says that the column must be derived from in-row data.

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

[CLANG10]

Thanks for the advise. I managed to work around the problem by creating a new table then these new calculated columns and linking relationship from this new table to the exisitng ones i got from the direct query from my data source. Still don't know the rootcause though.