Forum Discussion

KG1's avatar
KG1
Resolver I
3 years ago

Column cannot be pushed to the remote data source and cannot be used in this scenario

Hi
I am trying to create new column in a table I have connected to via a published dataset and am getting the following error
 
Column] cannot be pushed to the remote data source and cannot be used in this scenario
 
I have build permission on the dataset
Column =
VAR d = ", "
RETURN
    CONCATENATEX (
        FILTER (
            'All Payroll',
            SEARCH ( d & 'All Payroll'[Employee Number] & d, d & 'All Cards - P&F Fuel Data'[Driver Name] & d, 1, 0 )
                > 0
        ),
        'All Payroll'[Employee Number],
        d
    )
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    KG1 , Are you using direct query?

    For live dataset, you can create a column. And this should work in import mode

     

    Create this like a measure

     

    VAR d = ", "
    RETURN
    CONCATENATEX (
    FILTER (
    'All Payroll',
    SEARCH ('All Payroll'[Employee Number] , 'All Cards - P&F Fuel Data'[Driver Name], , 0 )
    > 0
    ),
    'All Payroll'[Employee Number],
    d
    )