web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 0O6Ew4HUMRNI4Qjh5DMtvw
Power Apps - Microsoft Dataverse
Answered

SQL Data is not Uploading to CDS

Like (0) ShareShare
ReportReport
Posted on 12 Jun 2020 18:49:51 by 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:
  • dyee4614 Profile Picture
    283 on 15 Jun 2020 at 16:12:22
    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 Profile Picture
    8,714 Most Valuable Professional on 12 Jun 2020 at 20:23:46
    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.

    2020-06-13_8-19-14.png

    2020-06-13_8-18-50.png

    Hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics