Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cannot Browse XMLA dataset with SSMS

I'm having trouble working with a Power BI dataset as an XMLA endpoint from SQL Server Management Studio (SSMS V18.4).   I connect to a Power BI model in Power BI Premium Capacity using a very simp...
Need Help
  • saini_chandni's avatar
    saini_chandni
    6 years ago

    Hi,

     

    We faced same issue , but upgrading ssms v18.4 to ssms v 18.5.1 resolved our problem and now we are able to browse the cube/dataset.

     

    Thanks

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the reply Xiaoxin Anonymous .

 

To be clear, all operations with Analyze in Excel work properly, initial connection with SSMS appears to work properly as well (I can expand databases and Tables and can even dump table contents with an EVALUATE statement in a DAX query).  My trouble comes when I try to right-click a database and choose Browse...

 

I have tried all three authentification methods:

  • Azure Active Directory - Universal with MFA
  • Windows Authentication
  • Azure Active Directory - Password

All three allow me in and all fail in the same manner.

 

Perhaps I don't understand enough about the authentication methods to be able to answer your question.

 

Anything else you can offer would be appreciated.

 

thanks,

 

Dale

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

If the issue only occurs when you view on the browser, I'd like to suggest you contact to power bi team to confirm if any compatibility issue with analyze in excel and corresponding drivers.
Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous- I'm puzzled by your response - I don't know if I havn't made my question clear or whether your answer has gone over my head.

     

    My question has neither to do with Analyze in Excel nor with a web browser.  It has to do with the "Browse" feature in SQL Server Management Studio when you right-click a database.