Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

BrookBracewell2

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

Submitted by on ‎07-05-2022 07:40 AM

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
See more ideas labeled with:
7 Comments (7 New)
Comments
BrookBracewell2
Frequent Visitor
‎07-05-2022 07:41 AM

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
‎07-05-2022 08:28 AM

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

Anonymous
Not applicable
‎07-06-2022 10:05 PM

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
‎07-07-2022 02:22 AM

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
‎07-07-2022 02:36 AM

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
‎07-07-2022 02:59 AM

OK- I am a fool -

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

 

Anonymous
Not applicable
‎07-07-2022 11:44 PM

Hi @BrookBracewell2 

So, can they export and share now ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses