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

Hey robarivas 
I can't get the Datamart connection string to work in Excel via its PQE. You say you can just pop the string in as-is? Can you share a screenshot or any configuration choices you've made? 
Cheers! James

robarivas's avatar
robarivas
Post Patron
4 years ago

No configuration choices made except when given the credential choices between Windows, Database, and Microsoft account I chose Microsoft account.

  • 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