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 :
Power Apps - Microsoft Dataverse
Unanswered

Dataflow not refreshing

(0) ShareShare
ReportReport
Posted on by

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
    Re: Dataflow not refreshing

    @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
    on at
    Re: Dataflow not refreshing

    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
    Re: Dataflow not refreshing

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

  • Community Power Platform Member Profile Picture
    on at
    Re: Dataflow not refreshing

    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
    Re: Dataflow not refreshing

    @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
    on at
    Re: Dataflow not refreshing

    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
    Re: Dataflow not refreshing

    @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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics