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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Juuls 

 

If the values of font column have some Special characters?

Or if your connection mode is direct query or live connection?

You should ensure that the data types for date and/or time fields are consistent both in your SQL database and Power BI. If there’s any discrepancy, it could lead to conversion errors.

 

Best Regards,

Zhengdong Xu

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