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

[philipm]

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

Cluster URI https://wabi-north-europe-redirect.analysis.windows.net/

[AlexChen · Accepted solution]

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]

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.