cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Administrator
Administrator

Do you belong to a local Power Platform User Group?  Want to let the world know?  Claim your badge!

Here is your opportunity to show your pride in your local User Group.  Just fill out the brief form at http://aka.ms/ugbadgeform and receive your User Group Badge.

You'll be asked

  • Which User Group you are a member of (Power BI User Group, Power Apps User Group, or Power Automate (Flow) User Group)
  • Your Power Platform Community Username
  • The URL of your Power Platform Community Profile (To find this, just click on your avatar and choose "My profile" from the dropdown.)
  • What chapter you are a member of (This is the location of your User Group.)

It's that simple! Start showing your pride in your local User Group today!

Click here to learn more about joining your fellow local Power Platform users in-person at the next ...

Dynamic Communities also offers more great opportunities to join the official User Groups of other Microsoft products and services!

User Group images.png

Regular Visitor

Among the latest features released by Microsoft, we have the possibility (finally!) of being able to connect in the cloud to the Common Data Service (CDS) database to perform our queries. The SQL connection provides read-only access to the entity data of the target CDS environment. Below I show you all the necessary steps.

First of all, make sure you have the SSMS updated version at least 18.4:

 

1

 

Next you need to enable the TDS endpoint functionality. These settings can be found in the Power Platform admin center by going to: Environments > [Your Environment Name] > Settings > Product > Features > TDS endpoint:

 

3

 

Well, now you have all the requirements to be able to connect. Now, open SSMS and enter the following information to perform the connection:

  • Server Type: Database Engine
  • Server Name: [your organization name],5558
  • Auth: AAD – Password
  • Username: [your username]
  • Password: [your password]

Notice that the Server Name is the organization address URL followed by a comma and the port value of 5558:

 

2

 

After establishing the connection, you will be able to see all the tables of the CDS:

 

4

 

The list of supported SQL operations includes:

  • Batch operations (such as Backup, Synchronization, etc…)
  • SELECT
  • Aggregation functions (i.e., Count() and Max() functions)
  • UNIONs and JOINs
  • Filtering

IMPORTANT! the Common Data Service endpoint SQL connection uses the Common Data Service security model for data access and is read-only. Data can be obtained for all entities to which a user has access to in Common Data Service.

 

5

 

Hope it helps and happy 365Power’ing!