Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Frixel
Post Prodigy
Post Prodigy

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 Prodigy
Post Prodigy

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 Prodigy
Post Prodigy

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.

 

mahoneypat
Employee
Employee

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
Super User

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors