Answered

SQL Data is not Uploading to CDS

(0) Share

Report

Posted on by dyee4614

283

Hi. I'm not sure what I did wrong here. I went to the CDS, clicked grabbed data, connected to our SQL database, removed the fields I didn't want and created the new entity. The entity has all the fields I selected but there is no data inside it.

Categories:

Dataflows

Entities

All responses (2)

Answers (1)

dyee4614 283 on at

Like (0)

Report

Re: SQL Data is not Uploading to CDS

I just clicked get data. I tried it again using dataflows and it worked perfectly, thank you!
Verified answer

EricRegnier 8,714 Most Valuable Professional on at

Like (0)

Report

Re: SQL Data is not Uploading to CDS

Hi @dyee4614,
I assume you're using Dataflows? Seems like your entity was already created before hence why you would get the all the fields and that your Dataflow didn't run successfully. If you navigate in maker.powerapps.com -> Data -> Dataflows, you should see the list of them. Is there a Last Refresh date and a little Warning icon (see image below) next to the date? If so, click on the icon and it will open the history with a status of your execution. You can download the log to see what happened.
Suggest to delete the entity and retry with a CDS system admin account that has MFA disabled so future runs wouldn't give you an authentication error.
Hope this helps!