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
JGrant8708's avatar
JGrant8708
Frequent Visitor
4 years ago

Interesting. That's what I've selected each time too (use the MS Account). 
Elsewhere in the thread MS has noted needing Private endpoints to be configured, reading into it now. 

marekr's avatar
marekr
Microsoft Employee
4 years ago

Private Endpoints are NOT currently supported for datamart connectivity (documented in limitations), so it might explain why you can't connect, if you have them enabled for the organization.

  • JGrant8708's avatar
    JGrant8708
    Frequent Visitor
    4 years ago

    Thanks marekr 

    I've logged the support ticket to my IT team and once I've confirmed our Private Endpoint status, I'll mark one of your replies as the Solution (in all likelihood). 
    Shall await Private Endpoint enabling at a later date! (something to look forward to ;))
    Will look back. 
    Cheers, James

    • JGrant8708's avatar
      JGrant8708
      Frequent Visitor
      4 years ago

      Hey marekr 
      Ticket came back - and we don't have Private Endpoints enabled. 
      Whilst I'm more practiced with ADS, I'll see if I can install SSMS v18 as mentioned elsewhere in this thread and get it to work. 
      Cheers, James

      • marekr's avatar
        marekr
        Microsoft Employee
        4 years ago

        Hi James,

         

        If Private Endpoints are not enabled it might be a problem of your organization's firewall blocking outbound connections to port 1433. Could you try connecting from a device outside of your organization's network? If that also doesn't work please open a support ticket and give us some identifiers like your datamart url or endpoint you're trying to connect to.

         

        Thanks,

        Marek