Unable to connect Azure SQL under datamart with SSMS

[Anonymous]

Hi all, I am trying to connect Azure SQL under datamart with SSMS in order to backup the data on-premises. But I couldnt access it with the connection string provided by the datamart server setting in power bi service.

The connection error in ssms:

Server Type: Database engine

Authentication method: Azure Active Directory - Universal with MFA

Alternatively, is there better ways to backup data from datamart to on premises SQL server

[Burtius13]

Hi @Anonymous ,

Did you able to solve your issue? because I couldn't find a solution via accepted answer. Thanks in advance

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Please check if your gateway configuration is accurate. Please see the following related articles:

https://community.powerbi.com/t5/Service/Datamart-unable-to-connect-to-Azure-SQL-DB/m-p/2555310 

https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-create-reports#create-reports-using-power-bi-desktop:~:text=Complete%20the%20following,in%20your%20dataset. 

And regarding the creation of a dataset from the datamart in the cloud, it auto generates one for you with direct query to build reports. In case you want to build them in a different workspace you need to be member or admin in the workspace of the datamart.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien