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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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