cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
masterOfNone
Level: Powered On

SQL Server Data Sync to Common Data Service Entity

I'm wondering if there is a way to continuosly integrate data from an external SQL database into a common data service entity. For example, let's say I have a table of budgets in a SQL server on premise, and I also created a matching entity in the COmmon Data Service for Apps. Is there any way for me to automatically keep the new and changing data from the SQL server table to the data entity? I see you can do a one time import of data, but I am wondering if it's possible to keep an active, one way sync?

4 REPLIES 4
PowerApps Staff CWesener
PowerApps Staff

Re: SQL Server Data Sync to Common Data Service Entity

Adding @millopis from the PowerQuery team who is working in this area.

Thanks,
Clay.
PowerApps Staff millopis
PowerApps Staff

Re: SQL Server Data Sync to Common Data Service Entity

Scheduled Refresh is currently available only in the Data Integration for Admins capabilities (from Admin Portal).

 

Support for Scheduled Refresh for Data Integration projects in the PowerApps portal is a work-in-progress and we expect to deliver this capability over the next couple of months. Currently, refresh can be done only manually.

 

Thanks,
M.

goobernoodles
Level: Powered On

Re: SQL Server Data Sync to Common Data Service Entity

This would be fantastic.

Dippa
Level: Powered On

Re: SQL Server Data Sync to Common Data Service Entity

Looks like this is available now, but I keep getting the following error:

 

Bad Request {"error":{"code":"0x80042f0a","message":"Principal team (Id=0c3747fc-f0dd-e811-a977-000d3......

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,343)