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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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 I
Resolver I

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 I
Resolver I

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.