Usage Metrics Report dataset has invalid relationship for Users table

[KrishnaPaudel]

Hello,

We are experiencing an issue with the new Usage Metrics Report dataset. We have a direct query to this dataset to pull the usage metrics into custom usage report that we have built. 

From Feb 16th onwards, we are getting the below error while querying the dataset.

"The query referenced column 'Users'[UniqueUser] which depends on another column, relationship or measure that is not in a valid state"

Snapshot of the error:

This is happening in two of our workspaces, however the usage models on all other workspaces do not to have this problem.

Tags: UniqueUser; referenced column 'Users'[UniqueUser]; 'Users'[UniqueUser]; usage model error;

[ferzfeld]

We have the same problem!

The usage metrics report is showing the exact same error message, and in the graphics it is not showing any data at all.

The "old" version is still working, but it is not showing the users to me (although I am the tenant admin and have assigned myself the right to see the users).

Any news about this issue?

[RaphaelYusen]

Dear @KrishnaPaudel @v-yangliu-msft ,

I do have same problem for weeks and still unsolved , as my IT department is of no support , could you please assist me to generate the Suae metrics report ? I got below error message :

Activity ID: b99f6d02-010b-46c7-b443-4c559b2dfad4
Request ID: 4666c4ab-5b4a-6301-ca41-7ceccb53c33b
Correlation ID: 84a6ede2-bc37-1212-0a8a-0e865b3f01b6
Status code: MoreThanOneDuplicatePackageFoundError
Time: Mon Apr 12 2021 14:29:27 GMT+0200 (Central European Summer Time)
Service version: 13.0.15854.62
Client version: 2104.1.05620-train
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net/

[v-yangliu-msft]

Hi  @KrishnaPaudel ,

Is there any update to power bi services so that the system cannot understand the type of data

For related content, you can check the following link:

https://community.powerbi.com/t5/Service/The-query-referenced-column-which-depends-on-another-column...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @KrishnaPaudel 

If it is working in other App Workspaces I would think to log a support ticket to see why this is happening?

https://powerbi.microsoft.com/en-us/support/pro/