The column cannot be pushed to the remote data source and cannot be used

Yiyi_1989 — Mon, 14 Aug 2023 18:36:09 GMT

Hello,

I created a table and gained a list of user_id of internal users. Then I tried to use this list to create a new column in my main table by matching the user_id with the list of user_id of internal users. However, I got the error message that "The column cannot be pushed to the remote data source and cannot be used in this scenario". Can some one help? Thank you so much in advance!

The DAX code of the table expression which gained the list of user_id of internal users:

internal user = SELECTCOLUMNS ( SUMMARIZE ( CALCULATETABLE ( 'Main table', 'Another table'[Type] = "Internal" ), 'Main table'[user_id] ), "user_id", 'Main table'[user_id] )

I tried to create a new column in my main table by using the values from tne internal user table but got the error messages mentioned above:

User Type = SWITCH( TRUE(), CONTAINS('internal user', 'internal user'[user_id], 'Main Table'[user_Id]), "Internal users","Other Users" )

Re: The column cannot be pushed to the remote data source and cannot be used

AnthonyGenovese — Mon, 14 Aug 2023 18:42:15 GMT

Personally, I would do all of this in Power Query. Create a new query for what you are looking for, then join that query to get your new column.

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

topic The column cannot be pushed to the remote data source and cannot be used in DAX Commands and Tips

The column cannot be pushed to the remote data source and cannot be used

Re: The column cannot be pushed to the remote data source and cannot be used