Forum Discussion
Date format in Direct Query not working
Hi,
I am using a direct query setup to make my dashboard and the date in the SQL table is in the format "dd-mm-yy" (example: 25-01-23).
I changed the date format in the front end of Power BI Desktop as shown below (snippet 1) and then load the column in a table. However, I am getting a "out of range" error (snippet 2). Can anyone please help.
Please note that the exact same process works when using import mode (without using Power Query).
Snippet 1
Snippet 2
Hi Analytics1 ,
Please try to get it as a TEXT rather than DATE datatype in Power BI.
I have also found a similar post, please refer to it to see if it helps you.
Solved: Text to date conversion problems - Microsoft Power BI Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Analytics1 ,
Please try to get it as a TEXT rather than DATE datatype in Power BI.
I have also found a similar post, please refer to it to see if it helps you.
Solved: Text to date conversion problems - Microsoft Power BI Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.