Forum Discussion
jitchen
2 years agoNew Member
DirectQuery with Date Function in PowerBi
Hi, not sure is there anyone faced this issue before. Before this I have no issue using Date(year,month,day) function with DirectQuery(Connect to SQL Server). Currently it pops up this error: ...
- 2 years ago
Probably bad data, like February 29th 2023.
lbendlin
2 years agoSuper User
Probably bad data, like February 29th 2023.
- jitchen2 years agoNew Member
Ya, I think this was the issue. I convert the date format via view there is no such issue.
- Anonymous2 years agoNot applicable
Hi jitchen ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards