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

Lost table relationships when converting Live Connection to Direct Query.

Premium Workspace Dataset from SQL Server Analysis Services database.

Get Data > Power BI Dataset > 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

    that is not supposed to happen! Can you tell me more about the relationships? Maybe look at the properties over in SSAS to see if any of them have special flags on them?

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