Forum Discussion
Report Visuals for Some End Users in Web Service Not Displaying
Hi Anonymous
What is the datasource of the local dataset model ? If it is Import connection mode , when you add the users in you workspace and give them the view role, they can access the corresponding report . If you connect to datasource with Live connection mode , you need map user in gateway .You can refer to the link below to learn how to map user in gateway .
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas
Best Regard
Community Support Team _ Ailsa Tao
Hi Anonymous
The dataset is a local model for the specific report containing Live connection to some tables in a Power Bi dataset and some manually entered KPI data in Power Bi tables. The KPI-only data visuals show for the users, but any visuals holding data from the Power Bi datasets error so it is an issue authenticating to the Power Bi dataset. The user has Read permissions on the Power Bi dataset and can happily view other reports built from it (the Power Bi dataset is an import mode dataset reading from SQL Server).
How do I authenticate the user for this? There is no Gateway to the Power Bi dataset and the user has permissions to the report and Power Bi dataset already.
Oddly, this report works for a user who does not have any Permissions on the Power Bi dataset. I can't remove this access though as the user needs it for other reports.
Thanks