ALM Toolkit compare does not work with user-context aware calculated columns

Open
#377 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
45/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Quiet
Tech stack
csharp
Domain
tooling

Research direction

Start with the ALM Toolkit comparison pipeline and reproduce the failure using a model containing a user-context aware calculated column, as described in the issue. Verify behavior when the column is in either source or target and when another object is updated; done means the comparison and update complete without the reported validation error.

Written by the indexing model from the issue text.

Description

The ability to create user-context aware calculated columns in Power BI has recently been released in preview. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-columns

If I try to use ALM Toolkit to update a model that includes this functionality then I get the error message
"CUSTOMDATA, USERNAME, USERCULTURE and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functions may only be used in Measures or in the AllowedRowsExpression."

This happens whether the column in question is in the target or the source. It even happens if I am not trying to update the object with the calculated column but, rather, some other object in the model.
My question is if there is a fix for this in the pipeline?

Dominant language
C#
Stars
732
Forks
433
No merged PRs in 30d

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from microsoft/Analysis-Services

All issues in microsoft/Analysis-Services

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.