Forum Discussion
Problem in share report in My Workspace
Hello all,
I have created a report by creating direct query from SAP HANA to power BI. I have joined 3 tables and created a query with mant calcultaed fields. I share the same report with My Workspace and share the same report from My Workspace to users in my organization with full read, reshare and edit access. All users have Power BI Pro license.
It is an exact copy of Qlik Sense report and all users have access to dataset. Still users gets an error message saying "This visuals cntains restricted data" . All the users have full access for dataset in Power BI and database in SAP HANA.
Upon many trials and error I created a new workspace and gave those users access as "Contributor" and share report from that workspace. Then those users can see the data.
Please help me understand if we could share the reports from My Workspace or not? In all the portals, Power BI team has saying we can share from any workspace. Please let me know if I am missing anything from my end or users end.
Thanks.
1 Reply
v-lili6-msftCommunity Support
hi, pawand23
Please check the permissions of the dataset and report
https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions
https://docs.microsoft.com/en-us/power-bi/service-share-dashboards
and if there is RLS in this report, go to the RLS (Row-Level Security) settings (in the online version) on the datasets via the three "..."
In the RLSview you'll have to choose every single person you've shared the data with and enter their e-mail once again, and press "Add" and then "Save" in the buttom.
Best Regards,
Lin