Shared report does not show data

Question

I have built a new report and shared with staff with pro license and they can't see the report, it comes as attached.

Once they click on see details it comes a message as attached.

I see the report with no problems.

I have been sharing other reports with the same people and never had this issue.

Any clue on what is causing this issue?

anonymous · Answer

Is this a Live Connection or Direct Query model?&nbsp; Is there security being applied at the data source?

anonymous · Answer

It is a Direct Query model. Only certain people has access to the database.I have shared files from the same database with the same people and they can access it.

anonymous · Answer

Thing you need to check:&nbsp; Does each person who is using this report have access to the Tables and Queries being run?
&nbsp;
When you set up a Direct Query, you can choose to pass through the user's authentication, or make use of the one listed in the Gateway.&nbsp; The error makes me suspect you are passing this through and therefore you need to ensure all of the security is set up for each user.

v-yulgu-msft · Answer

Hi&nbsp;Anonymous,
&nbsp;
What is the data source? Which authentication type did you choose when&nbsp;specifying credential in desktop?
&nbsp;
Regards,
Yuliana Gu

anonymous · Answer

It might have been a temporary glitch in the system. It is working now. Thanks

Forum Discussion

Shared report does not show data

6 Replies

Related content

Report Sharing

Report sharing strategy

Share report with external

Sharing the report

Sharing report with Composite Model does not work