Forum Discussion
Solved
Not able to create a column.
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...
correct. You can only add columns in Import Mode or in Mixed Mode (Direct Query with local data model). Not for Live connection.
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/
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.