cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frixel
Post Partisan
Post Partisan

Error date modified and date created

Hi All,

 

What could be the problem if I let Power Bi look at a folder in sharepoint and this error appears.

These are all files that have been placed in the folder by power automate.

 

2.png

1 ACCEPTED SOLUTION
Frixel
Post Partisan
Post Partisan

I solved it by setting the "regional settings" of the file to 'English (united states)' in the settings of Power Bi.
Then a refresh and choose the option date / time in the options of the column.

6.png

 

I think that is very strange because the "Global" settings of Power Bi were also already on  'English (united states)'

7.png

 

So it is resolved but i don`t understand it.

 

View solution in original post

5 REPLIES 5
Frixel
Post Partisan
Post Partisan

I solved it by setting the "regional settings" of the file to 'English (united states)' in the settings of Power Bi.
Then a refresh and choose the option date / time in the options of the column.

6.png

 

I think that is very strange because the "Global" settings of Power Bi were also already on  'English (united states)'

7.png

 

So it is resolved but i don`t understand it.

 

View solution in original post

mahoneypat
Super User IV
Super User IV

If you have a Changed Type step in your query, update that to convert those columns to Text first (instead of DateTime) to see what the values are to help troubleshoot.  If that is successfull, right click and choose to date using locale to see if that successfully converts it.

Change Type Using Locale with Power Query • My Online Training Hub

 

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


It doesn`t matter when i changed to localy type, the error apears.

 

4.png

 

even when i make it tekst then the error`s appears😂

5.png

lbendlin
Super User III
Super User III

when you click on one of the Error links you should get more details.  Likely a format/locale mismatch.

Hi @lbendlin 

 

See the image below.

As you can see is the file created this morning (17-04-2021) today and when i click on the 'Error' then it says that it is from 16-04-2021.

Also with the file above it it is the same error.

 

Files that are createt in the afternoon don`t have the error.

So i think it is a time issue but how can i resolve this?

 

 

 

2.png

 

And this is the properties from the file in Onedrive.

3.png

 

So the diffetent is 1 day and 3hours 🙄

I don`t understand it.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors