Connecting to CDS from SQL Server Management Studio

[hector-konomi]

I saw the presentation at the summit, that you can connect to the CDS instance from SSMS. What are the steps to accomplish that?

[Zion]

Hi @Syndicate_Admin 

It's all here

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query

[Syndicate_Admin]

Hi ,

I tired this but its not connecting. want to know the regions for which this is available. I can see from the org url configured is for US region. Tried creating a trial for this purpouse its not onnecting.

Any help will be really appreciated.

Regards,

Sarath Mohan

[nickyvv]

Hi @SarathMohan,

the link provided shows the following:

Could you please check if that option is enabled by trying the following?

You can use the Analyze in Power BI option (Data > Entities > Analyze in Power BI) in Power Apps (https://make.powerapps.com) to use the SQL connection feature to analyze data in Power BI Desktop. More information: View entity data in Power BI Desktop.

[Syndicate_Admin]

No There is no option available in the command bar tried with multiple instances. No luck

Are you able to see this option. I have navigated to Data--> Entities and in the command bar didn't find any option.

Sarath