Subject pretty much explains it. I have an on-premesis sql table of about 2500 items. I want to push it up to CDS, so I can get to it quicker in powerapps. Can do? I also want it to stay sync'd. One-way. The on-prem will always be the table getting new data. No need to change it in CDS.
What think you?
Yes, you can add data from SQL to an entity in Common Data Service for Apps by using Power Query. You can also filter, transform, and combine data before you load it into a new or existing entity. For detailed steps and information, please have a look at:
I suggest that you load the data to a new entity. If you use Power Query to add data to an existing entity, all data in that entity will be overwritten.
For the future data syncing, you could use a Flow like below to achieve this.
Are there any limitations to the CDS entity (table)? Like database size in bytes, or number of records?
Plus, what might I expect for my complex lookups as a performance improvement?
Is this a good way to do this?
I'd like to refresh this a bit. I do need to know if there are performance gains expected using CDS over an on-prem gateway SQL table(s). It has been a bit of a chore to do an initial dump of tables into CDS. Getting errors. Thats not my quesiton here, but is it even worth my effort. I have many complex calls to SQL tables throught my on-prem gateway that is making my app quite slow. Plus, I'm the only one using it. There will be 10+ using it when it goes production. Please advise on this, or other ways to improve performance.
Things I have done to improve speed:
- Create views from SQL tables, to reduce the number of nested loop filters, and complex and/or search criteria.
- Redesigned interface to pull in data to a reduced set of results.
- Limited search results, requesting user to tighten their search
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.