Forum Discussion
PowerNewUser
Resolver I
2 years agoOneLake Data Access + Live Connection = No Access in reports.
I recently enabled Data access roles in my lakehouse but cant get downstream users to access reports (they get errors on the visuals related to access). Would appreciate if anybody could help with wh...
- 2 years ago
Figured out the problem - seems copilot was on the right track. Due to enabling the preview the READDATA is no longer coming up as a permission. I had to manually go in and give access to the schema
GRANT SELECT ON SCHEMA::dbo TO [<entra group>];GO
if you need to give table level access - you can doGRANT SELECT ON OBJECT::dbo.<table name> TO [<entra group name>];
Anonymous
2 years agoNot applicable
Hi PowerNewUser ,
Could you check whether the user has access rights to all of the following items?
1\ Semantic Model
2\ LakeHouse
3\ SQL analytics endpoint
4\ Report
You can check the user's permissions by clicking "Manage Permissions" on each item.
Best Regards,
Wearsky
PowerNewUser
Resolver I
2 years agoThank you.. With the new preview ReadData is not showing up even when you select the option.