Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Unable to connect Azure SQL under datamart with SSMS

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 i...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

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