cancel
Showing results for 
Search instead for 
Did you mean: 

Report Connected to Scorecard Data set won't allow some users to connect to the data

I created a Score Card (Metrics/Goals) and subsequently generated a report in Desktop, connected to the Data Set- along with a date dimension.

The subsequent report can be run and seen by me and some users in my team, but when testing with a test user it is failing

 

Please see screen shots 

Status: Needs Info

HI @BrookBracewell2 

Can you explain what is "testing with a test user it is failing" ? What is the difference between them and the users in your team?

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
BrookBracewell2
Frequent Visitor

BrookBracewell2_0-1657032058548.png

 

BrookBracewell2_1-1657032065002.png

 

BrookBracewell2_2-1657032073760.png

 

BrookBracewell2_3-1657032079789.png

 

BrookBracewell2_4-1657032086416.png

 

Activity ID: d9452a10-2063-4bfc-8e9d-7c898aefe0c8

Request ID: 659574eb-c392-010f-1824-7857d79031f4

Correlation ID: a72d43fa-1e08-32b5-b383-a85817e3481a

Time: Tue Jul 05 2022 15:38:58 GMT+0100 (British Summer Time)

Service version: 13.0.18530.39

Client version: 2206.3.12016-train

Cluster URI: https://wabi-uk-south-c-primary-redirect.analysis.windows.net/

BrookBracewell2
Frequent Visitor

I had added screen shots- perhaps they will land in a few minutes- I can confirm when connecting to the composite model (Which is in Service) as the TestUser I can sucessfuly bring in a visual based on tables imported from SQL data, but "Forbidden" on the Goals/Metrics data set

Ailsa-msft
Community Support
Status changed to: Needs Info

HI @BrookBracewell2 

Can you explain what is "testing with a test user it is failing" ? What is the difference between them and the users in your team?

 

Best Regards,
Community Support Team _ Ailsa Tao

BrookBracewell2
Frequent Visitor

This is the million Dollar question.  My test user possibly has a lesser Microsoft licence- but I have also tested with other users in the business. I can't identify what is different between my team of 4, and the users who are failing.

 

My test user can create a report in Service using the Goals/Metrics Dataset, 

My test user can create a report in  service using the composite data set - using the date table

My test user fails to create a report in service  using the compsite data set using the tables from the Goals/Metrics Dataset

BrookBracewell2
Frequent Visitor

OK an update-  in desktop as BITestUser I get the message below.  But I can't see where this setting is - the user is confirmed as ADMIN on both the data set, and the workspace

 

BrookBracewell2_0-1657186544768.png

 

BrookBracewell2
Frequent Visitor

OK- I am a fool -

Admin,Export and Sharing,Live Connection was set to my team only

 

Ailsa-msft
Community Support

Hi @BrookBracewell2 

So, can they export and share now ?

 

Best Regards,
Community Support Team _ Ailsa Tao