Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
domputer's avatar
domputer
Frequent Visitor
4 years ago

Please provide additional information regarding finding special flags ?

 

Tried accessing data base directly, same issue
Get Data > SQL Server Analysis Services database > Table Relationships exist
Make Changes to the Model > Table Relationships disappear except one.

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

you 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.

  • domputer's avatar
    domputer
    Frequent Visitor
    4 years ago

    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 ?