cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Power Apps
Power Apps

Re: SQL Server Data Sync to Common Data Service Entity

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

Thanks,
Clay.
Highlighted
Power Apps
Power Apps

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.

Highlighted
Advocate III
Advocate III

Re: SQL Server Data Sync to Common Data Service Entity

This would be fantastic.

Highlighted
Frequent Visitor

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
secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (6,982)