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 this due to the datasource setting? Need advise on how to resolve this. Thanks!! 

 

 

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.

4 Replies

  • 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?