Forum Discussion
Datamart (SQL) Server Connection String Details - Port number? Share email?
It's the standard port number (1433). Please make sure you use the latest SSMS and ADS versions. It won't connect with older versions. For SSMS please select "Azure Active Directory - Universal with MFA" Authentication.
Thanks marekr
I've appended ",1433" in ADS (latest version, fresh install on a new PC today) and am now receiving a connection issue:
Still progress as it's a different error at least!
I've also received confirmation that the Share email did go through to one of my colleagues, though I'm unsure if they're able to connect using it (they haven't had the time as yet).What might loosen this security issue? (it's a Datamart in a Premium workspace that I'm an Admin of and I created/refreshed the Datamart, all using the same personal AD account)
Cheers! JamesHi James, can you please confirm that you don't have Private Endpoints enabled for your organization in Power BI? See Private endpoints for accessing Power BI - Power BI | Microsoft Docs
Hey marekr
I will check with IT about this point. If I had to gues I would say that we DO have Private Endpoints enabled - it seems like the type of thing the organisation would prefer to do (keep all of our traffic within the MS network until absolutely necessary).
If we DO have it enabled, what's the approach?
Cheers, James
By copying and pasting the link in the SSMS server name tab with Servertype as Analysis services, we are getting the Claimstoken error. we tested with SSMS version v18.9.1 and not able to access.
Can someone help me on this
