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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Bieke

report build on top of composite model in Power BI service not visable for our users

Submitted by on ‎02-17-2022 09:21 AM

Hi All,

 

We are having issues with a report build on top of a composite model in Power BI service.

The report cannot be viewed by users with read role in the workspace. Those users get the below message:

 

Couldn't load the data for this visual
 
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.

 

The composite model in the workspace (workspace A) consists of a SharePoint-dataset and a Power BI dataset based in another workspace (workspace B).

 

All our users have a PRO-license.

 

Our test-user has a read role in workspace A, has access to the SharePoint-dataset and read-access on the dataset in workspace B. So, all his authorizations seems fine, but he nevertheless can't view the report.

 

We found a workaround to solve this:
when we give build permission on the dataset in workspace B to our test-user, he is finally able to see the report.

 

That’s a good workaround, but that is not a solution in the long run.
We don’t want to give the users with read permission (read role) in the workspace build permission on the underlying dataset to be able to view the reports.

Status: Needs Info

Did you create a composite model by connecting both SharePoint and service datasets in Desktop ? What is the data source for your dataset in workspace B ? Can you describe in detail the steps to create a composite model report? I need to restore your scene as you said to confirm the permission problem .

 

Best Regard

Community Support Team _ Ailsa Tao

See more ideas labeled with:
2 Comments (2 New)
Comments
v-yetao1-msft
Community Support
Community Support
‎02-18-2022 02:02 AM
Status changed to: Needs Info

Did you create a composite model by connecting both SharePoint and service datasets in Desktop ? What is the data source for your dataset in workspace B ? Can you describe in detail the steps to create a composite model report? I need to restore your scene as you said to confirm the permission problem .

 

Best Regard

Community Support Team _ Ailsa Tao

Bieke
Regular Visitor
‎02-21-2022 03:01 AM

Below the answers to your questions:

 

Did you create a composite model by connecting both SharePoint and service datasets in Desktop ?

Yes

 

What is the data source for your dataset in workspace B ?

Azure SQL Server

 

Can you describe in detail the steps to create a composite model report?

We started in Power BI desktop in which we connected to the Power BI dataset (star schema) from workspace B in the service. Next we imported the necessary table from SharePoint (live connection switches to direct query). Then we linked this table to the starshema as a new dimension. We created a report on top, before  publishing it to workspace A.

 

Best regards,

Bieke

 

 

Idea Statuses