Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
)
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!
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |