I am pretty new to CDS. I have built a number of powerapps using Sharepoint lists as the datasource but recently built an powerapp that references data in an onprem SQL database table. Everything works but data load times are poor.
I am trying to setup a copy of the SQL table in CDS, initially for testing but then later as a live environment with changes in the onprem SQL table updating the CDS table automatically.
I am failing at step one at the moment. I can go into either "Data" or "Dataflows" from the powerapps portal, I can create a table in CDS (just has one column at the moment) and I can follow through some of the process i.e I can see the DB i want to connect to and can select the required table as well as select "Transform Data" and select all columns. When I click "Next", after about 20 seconds, I get the following error:
Unexpected result type of schema evaluation. Expected: "Table". Actual: "Exception".
I have searched the internet for this error but cannot find anything useful. I would be eternally grateful if anyone can shed any light on why I might be getting this error and more importantly, how to get past it!
I would like to suggest that you raise a support ticket by clicking the 'Create support ticket' button on the following page. That way, you'll have something that's a bit more traceable and you might receive a quicker response.
We will need to check more details about the issue.
I am BY NO MEANS an expert as I've only been playing around with PowerApps for a couple months, but I was getting the same error today. Decided to try to just add a record manually and got an error saying I didn't have permissions to the form (which I know I do). If I refreshed the form, it worked. So I logged out of Power Apps completely, and then tried reloading the data through the wizard and it worked fine. tl;dr log out, log back in and try it again.
Hi All, Unfortunately I haven't had opportunity to follow this up yet but will try to do so by the end of this week. I will let you know if I achieve any success.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks