Forum Discussion

JGrant8708's avatar
JGrant8708
Frequent Visitor
4 years ago

Datamart (SQL) Server Connection String Details - Port number? Share email?

Dear Community,  I have created a small testing Datamart based on this brand-new functionality. Works really well in the service/browser.  Would love to test that I can connect to my PBI Datamart t...
Need Help
robarivas's avatar
robarivas
Post Patron
4 years ago

So in addition to Excel I've managed to connect with Azure Data Studio but cannot connect with SSMS (despite following the steps in Microsoft's official Datamart documentation) nor with any other tool.

  • marekr's avatar
    marekr
    Microsoft Employee
    4 years ago

    Can you please confirm that you're using the latest version of SSMS? Only a few tools are supported right now, but SSMS is one of them and should work if you're on a recent version.

    • robarivas's avatar
      robarivas
      Post Patron
      4 years ago

      Thanks marekr . SSMS did not work with v19 Preview. When I switched to the Generally Available version 18 it worked. Is there a way to find out what tools are supported (and any connection instructions for each)?

      • marekr's avatar
        marekr
        Microsoft Employee
        4 years ago

        Thanks for letting us know about the v19 Preview issue. I've been using version 18 and that is the only supported version of SSMS right now. We'll look into why v19 Preview doesn't work.