Unable to connect Azure SQL under datamart with SSMS

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