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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Frixel
Post Prodigy
Post Prodigy

Data source error in query: Dutch UTC_Time

Hello,

 

Since yesterday i get this error in my query for "Dutch UTC_Time"

Frixel_0-1729146253806.png

 

Hoe can i resolve this issue?

 

10 REPLIES 10
AsNa_92
Resolver II
Resolver II

Right-click on top of your table and go to Advance editor and see your connection:

AsNa_92_0-1729510434658.png

 

 

if you could post your connection and blur any sensitve data, we may know the issue.

Hi @AsNa_92 

 

You mean this?

 

Frixel_0-1729510799207.png

 

see this,

 

if i now run the query it works.

Frixel_1-1729510961546.png

 

And 2 minutes later the same query it doesn`t works

Frixel_2-1729511001317.png

 

This is my version of Power Bi Desktop

 

Frixel_0-1729521111726.png

 

AsNa_92
Resolver II
Resolver II

Hi,

 

did you try to change the setting of date from options?

File> Option and setting > Options : choose Dutch

AsNa_92_0-1729150576162.png

 

Sometimes it works and sometimes it doesn't

 

Frixel_0-1729229578418.png

 

Hi @AsNa_92 

 

The setting is on Dutch

 

Frixel_0-1729151412978.png

 

Could it be that there is a maximum limit to how long you can refresh the data?

Since last Friday, no refresh has been successful.

I also regularly received a code 404 on the web page of http://worldtimeapi.org.

Could that have something to do with it?

Does anyone know if there is an alternative for this?

can you provide the M editor from the advanced query editor.

Also, try to install newer version of PBI desktop and duplicate the project with different name then open it.

Hi @AsNa_92 

What must i than to do in the M editor?

 

This is what there is now.

 

Frixel_0-1729506275215.png

 

I have the issue in more reports where i use this UTC query so i don`t  think that the rename and save as new report it not will help.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors