slicer not working in direct query but working in import mode in power bi

[Anonymous]

below error its showingurce.Error] ODBC:ERROR[HY000] ERROR: invalid parameters  types of function 'roun

[Anonymous]

Hi @Anonymous ,

If I understand correctly, the issue is that couldn’t fold the expression to the data source. Please try the following methods and check if they can solve your problem:

1.Ensure that the function round is being used correctly in the query.

In order to make a deep troubleshooting and give you a suitable solution, could you please provide the following necessary information?

1.What is the underlying data source?

2.Which visualization are you using?

3.Which related formula were used?

4.What fields were used?

Looking forward to your reply.

Best Regards,

Wisdom Wu

[Anonymous]

Hi Wisdom,

thankq for your Reply

1.Denodo

2.Tables,cards,slicers

3.We were used Calculated count measures

4.ID's ,Dtaes And Values