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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataflow not refreshing
Power Apps
Unanswered

Dataflow not refreshing

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I am trying to flow an excel sheet into dataverse, but refreshing keeps failing. This seems to happen when the excel table is larger. This is the error I am getting, thanks.

jgiemza_0-1655819940869.png

 

I have the same question (0)
  • AhmedSalih Profile Picture
    6,678 Moderator on at

    @Anonymous , it seems that you have a date format issue. Make sure that the date(s) column(s) in your excel sheet have valid values.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    The dates in my excel sheet seem perfectly fine. In the error it says the first date is 7/22/0221 but its not like that in the excel sheet. Also I have used the same data with less rows and it refreshes fine, I am not sure why that would be an issue.

  • AhmedSalih Profile Picture
    6,678 Moderator on at

    @Anonymous , are you importing the date column into a number column in Dataverse?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I was trying to convert them into dates in the flow, but I just solved that issue by formatting the dates in excel. Now I have another formatting issue with entities being too long. Do you know how to fix this? Thanks.

     

    jgiemza_0-1655822083876.png

     

     

  • AhmedSalih Profile Picture
    6,678 Moderator on at

    @Anonymous , Increase the length from your Dataverse column properties. 

    AhmedSalih_0-1655822270609.png

     

    Regards,
    Ahmed
    If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you that worked, but now I am getting this error. It seems to be in the first row and again that date looks correct in my excel sheet.

    jgiemza_0-1655823138692.png

     

  • AhmedSalih Profile Picture
    6,678 Moderator on at

    @Anonymous , Make sure that you Dataverse date column has these properties: (Highlighted in Yellow)

    Date Column Properties in Dataverse.PNG

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard