Forum Discussion

debiruman's avatar
debiruman
Frequent Visitor
1 year ago
Solved

Can't update semantic model in Power BI Workspace - Expression.Error

Hello! Can't update semantic model in Power BI Workspace. The semantic model is not updated in the workspace when you click update. Although there are no errors in Power Query and no issue when u...
Need Help
  • debiruman's avatar
    debiruman
    1 year ago

    That modification helped:
    CHECK_Event_NOT_Contains = Table.AddColumn(Event_Name_NOT_Acceptable, "CHECK_Event_NOT_Contains", each
    if Value.Is([Event_Name_NOT_Contains], type list) = false then "NOT_MATCH"
    else if List.IsEmpty([Event_Name_NOT_Contains]) then "NOT_MATCH"
    else if List.AnyTrue(List.Transform([Event_Name_NOT_Contains], (substring) => Text.Contains([Копия EventName], substring))) then "MATCH_TRUE"
    else "MATCH_FALSE"
    ),

debiruman's avatar
debiruman
Frequent Visitor
1 year ago

That modification helped:
CHECK_Event_NOT_Contains = Table.AddColumn(Event_Name_NOT_Acceptable, "CHECK_Event_NOT_Contains", each
if Value.Is([Event_Name_NOT_Contains], type list) = false then "NOT_MATCH"
else if List.IsEmpty([Event_Name_NOT_Contains]) then "NOT_MATCH"
else if List.AnyTrue(List.Transform([Event_Name_NOT_Contains], (substring) => Text.Contains([Копия EventName], substring))) then "MATCH_TRUE"
else "MATCH_FALSE"
),