Hi, i'm using clickhouse (an high performance column db) and i would like to connect it, using direct query mode, to powerBI.
Connections and data retrieval are working but, when I try to add some filters, i get this error:
Message: OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.. (Source: \\?\.....\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace2120396417\Data\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003).
Hi, i'm using clickhouse (an high performance column db) and i would like to connect it, using direct query mode, to powerBI.
Connections and data retrieval are working but, when I try to add some filters, i get this error:
Message: OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.. (Source: \\?\.....\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace2120396417\Data\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003).I guess this guy (https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Expression-Error-We-couldn-t-fold-the/m-p/462690/highlight/true#M214711) has the same problem as me.
Have you got an idea about this error?