Forum Discussion

Juuls's avatar
Juuls
Frequent Visitor
2 years ago
Solved

Conversion error when applying filter

Hi all,   Currently I am facing an error in Power BI which is as follows: I get this error whenever I apply a filter on a table. The table does not cause any error in SQL, which is why I am ...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Juuls ,

     

    Just for a test try to change the format of that column to a Text format instead of date time and see if still get the error? What I believe can be happening is the local settngs being inconsistent with SQL so instead of having dd/mm/yyyy you arwe getting mm/dd/yyyy (for example) that leads to errors in conversion.

Juuls's avatar
Juuls
Frequent Visitor
2 years ago

Hi all,

 

Thanks for the replies!

I have checked the format, since I am indeed using direct query, however without success.

Both the SQL data type als the data type in Power BI are set to Date time, but still the error arrises as soon as I filter a value in the table. Are there any other options to troubleshoot this?

Thanks once more for your help.

 

Best Regards,

 

Juul