Date format in Direct Query not working

[Analytics1]

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

[Anonymous · Accepted solution]

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 _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.