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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Error in Power query "DataFormat.Error: We couldn't convert to Date"

Hello,

 

I got an issue that as far as I saw no one has, this M function doesn't work in my case, I don't know why.

 

image.png

Anyone knows why?

 

Thank you!

 

 

Status: New
Comments
v-chuncz-msft
Community Support

@isThisABug 

 

You missed the parentheses.

DateTimeZone.FixedLocalNow()

 

isThisABug
Frequent Visitor

Yes! It was just that. But how do I differenciate between functions/methods that need parentthesis to work and those who are calling other methods? Power Query editor doesn't give me many hints. Just shows a purple box or a blue box between brackets and I dont get so well those concepts.

 

Also, how do I mark your comment as a solution or my post as closed?

 

Thank you @v-chuncz-msft !