Forum Discussion
PowerNewUser
Resolver I
Resolver IOneLake 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...
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>];
PowerNewUserResolver I
Resolver IFigured 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 do
if you need to give table level access - you can do
GRANT SELECT ON OBJECT::dbo.<table name> TO [<entra group name>];