Forum Discussion

CLANG10's avatar
CLANG10
Helper I
3 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

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

lbendlin's avatar
lbendlin
Super User
3 years ago

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

CLANG10's avatar
CLANG10
Helper I
3 years ago

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?