We used clickhouse db on our server and use data from there in power bi, but we are not able to refresh it everytime, it refreshes around 50%of the time successfully.
To connect to this data we use gateway from microsoft and odbc driver from CH.
Microsoft checked all logs in their services and didn't find that something was wrong on their side and they advised to contact you.
The message error is:
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ERROR [HY000] Incomplete input stream, expected at least 17 more bytes"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Deposits and users data.
FYI @[email protected] (Sante)
ClickHouse Case #00013258