Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Microsoft Employeeyou can use any SSAS client tool such as management studio or others to connect to the database. Please check for anything related to private on tables. we have had an issue before where if a table was private it would still be loaded and we have hence fixed it, but wondering if you are experiencing another issue related to it.
Can Microsoft confirm if this is the expected behaviour ?
Workaround after ongoing troubleshooting with user.
Issue related to table key columns being hidden due to Object Level Security being set in Azure SQL Server Analysis Services Database.
Relationships remained after converting from Live Connection to Direct Query when allocated Confidential role access in Azure.
So if a key column has Object level security then all relationships that use that column would be deleted.
Can Microsoft confirm if this is the expected behaviour ?