Forum Discussion

philipm's avatar
philipm
New Member
10 years ago
Solved

Couldn't load the data for this visual - for users outside organization

I have created a report with direct query access to the datasource.

I have shared the report with serveral users in my organization and it works fine.

 

But when I share the report with a user outside my organisation, the user has access to the dashboard but no data is shown.

 

The gateway and the datasource in the report is configured as public.

 

I hope you can help me.

 

Here the error 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.
Http Status Code 401
Activity ID 73b81716-f534-408e-98ae-480a0975a461
Correlation ID e56e3d0c-6935-51e6-9e62-4a45e990f434
Request ID 39b24194-d1ba-0375-ae7c-9769829b2f25
Time Thu Aug 18 2016 11:00:57 GMT+0200 (W. Europe Standard Time)
Version 13.0.1605.328

 

  • Hi,

     

    In Power BI Services, without Row Level Security set,  users outside organization can also view the data in shared dashboard successfully even they don’t have access to data source.


    However, if you set RLS on your dataset, those accessing users must be added to a role, otherwise they can see nothing on your shared dashboard. Please check RLS setting and try again.

     

    Best Regards
    Alex

2 Replies

  • AlexChen's avatar
    AlexChen
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi,

     

    In Power BI Services, without Row Level Security set,  users outside organization can also view the data in shared dashboard successfully even they don’t have access to data source.


    However, if you set RLS on your dataset, those accessing users must be added to a role, otherwise they can see nothing on your shared dashboard. Please check RLS setting and try again.

     

    Best Regards
    Alex

  • dimazaid's avatar
    dimazaid
    Icon for Microsoft Employee rankMicrosoft Employee

    For a live connection the Power BI Service account is passed as the effective username, so you need to make sure anyone looking at the report has access to the data source.