Forum Discussion

Analytics1's avatar
Analytics1
Frequent Visitor
3 years ago
Solved

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 Des...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.