Why was Dataset *build* access needed for Users to get access to a report?

[mmace1]

I have a Composite Model Report in Workspace 1 , that pulls from:

• Via Direct Query, Dataset A in Workspace 2
• Via Import, several additional tables

Because the Report lives in a different Workspace than Dataset A, I've had to specifically give Users *read* permissions for Dataset A.  Pretty...pretty sure just Read permissions

Until today, when users suddenly get "Couldn't load the data for this visual" errors.

It's fixed if I add *build* permissions to Dataset A. But, why...?

[v-xulin-mstf]

Hi @mmace1,

Refer to this post here. Your problem might be related.

The error you mentioned here is usually a transient issue, which I think might be related with the Data Source connection. Please try it again and see what happens.

Best Regards,

Link

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

[mmace1]

@v-xulin-mstf  Issue is still present. 

If I remove the build permissions, then users again get the "Couldnt load the data for this visual" error

[v-xulin-mstf]

Hi @mmace1,

Any RLS setting on published report? If this is a case, you need to assign roles to users.

Row-level security (RLS) with Power BI

Best Regards,

Link

[mmace1]

@v-xulin-mstf 

Thanks.  No RLS involved.  But  I have it working - just the users need read *and* build permission on the dataset suddenly, and several other users are reporting the same sudden experience. 

[v-xulin-mstf]

Hi @mmace1,

It is a known issue that Microsoft is currently working on. ICM: 218686013

I will update here when i got any response.

Best Regards,

Link

[mmace1]

@v-xulin-mstf 

Was there ever any update to this?  i.e. - live with it, or planned fix in Q2, etc?   I tested today, and the issue still seems to be present. 

[chaz2jerry]

Same issue in our setup, waiting for resolution and update!

[Anonymous]

I have the exact same issue. It seems like something has changed. 

I have a New Composite Model that uses a Power BI "Golden Dataset" in a separate work space as direct query. Then has a few tables that Import.
Users who have read access to the Golden Dataset are getting the "Couldnt load the data for this visual" error.

[chaz2jerry]

According to MSFT this is expected design/behavior, "Build" permission is needed on the golden dataset for all report consumers. I have found an Idea to require only "Read" permission, not "Build" permission for this scenario and voted, pls help vote this up.
https://ideas.powerbi.com/ideas/idea/?ideaid=6f4b0b13-d88d-eb11-8ced-281878ddff33

[mmace1]

That's fairly crazy, since it nullifies the point of having two seperate permissions.  But interesting, thanks!  Also voted.