Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Error reading Excel file from Powerapps

Hi guys,


Hope you can help with the following issue.


I have a PowerApps based on Excel Online file. Everything was going Ok but since a few days ago I'm getting this error when I open my app "not a legal oleaut date"


Any idea about this? I'm sure that everything on date fields on the excel are actually date and I tried to reload the file to OneDrive and then refreshing the PowerApps Connection but nothing



Powerapp error.jpg

Level 8

Re: Error reading Excel file from Powerapps





  1. Clear Cookies and Cache, and retry
  2. Remove and re-add the data source from PowerApps, then retry #1, then retry it.
    1. Also, after doing this, try clicking the refresh icon a few times in PowerApps Maker as well.
  3. Remove the Excel Online connection, and then if needed recreate the Connection by removing the connection under -> Data -> Connections -> Find Excel Online Connection -> Use Ellipses ->  Remove Excel Online Connection., then retry #2, then retry #1, then retry it.


Helpful resources

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.


Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (5,149)