Visuals returning errors when interacting with slicers

[dkarlstedt]

Describe the bug Visuals display the following error message sporadically when applying slicer selections:

To Reproduce Steps to reproduce the behavior:

1. Connect using the Clickhouse Power BI connector in DirectQuery mode
2. Set up one fact table and 1-2 dimensions tables with many-to-many relationships
3. Add one visual and some slicers, make selections and witness the visuals return errors sporadically

Sometimes, refreshing and selecting something else resolves this issue. These actions also produce the error. There is no logic at all.

Expected behavior No errors returned when interacting with slicers

Screenshots

Configuration

Environment

• PowerBI version: 2.137.952.0 64-bit
• power-bi-clickhouse version: 0.1.5
• ClickHouse ODBC driver version: 1.3.0.20241018
• Operating system: Windows 11 Enterprise

Additional context For a few minutes (1-2) it can work perfectly, then the errors occur. Leaving the app for a few minutes then refreshing resolves the errors. Altering the semantic model almost always produces more errors. Restarting Power BI temporarily resolves the issue.

[BentsiLeviav]

Hi @dkarlstedt

Thanks for sharing your issue. Would you mind doing the following:

• Enable PowerBI tracing and share the logs - here is a guide on how to do that.
• Start ODBC tracing and attach the logs
• When getting this error, would you mind checking system.query_log in your ClickHouse instance to see if there is any incoming request?