{"action":"created","issue":{"url":"https://api.github.com/repos/yandex/clickhouse-odbc/issues/92","repository_url":"https://api.github.com/repos/yandex/clickhouse-odbc","labels_url":"https://api.github.com/repos/yandex/clickhouse-odbc/issues/92/labels{/name}","comments_url":"https://api.github.com/repos/yandex/clickhouse-odbc/issues/92/comments","events_url":"https://api.github.com/repos/yandex/clickhouse-odbc/issues/92/events","html_url":"https://github.com/yandex/clickhouse-odbc/issues/92","id":340079812,"node_id":"MDU6SXNzdWUzNDAwNzk4MTI=","number":92,"title":"The ODBC error connect Power BI","user":{"login":"DandelionWenjing","id":33156672,"node_id":"MDQ6VXNlcjMzMTU2Njcy","avatar_url":"https://avatars1.githubusercontent.com/u/33156672?v=4","gravatar_id":"","url":"https://api.github.com/users/DandelionWenjing","html_url":"https://github.com/DandelionWenjing","followers_url":"https://api.github.com/users/DandelionWenjing/followers","following_url":"https://api.github.com/users/DandelionWenjing/following{/other_user}","gists_url":"https://api.github.com/users/DandelionWenjing/gists{/gist_id}","starred_url":"https://api.github.com/users/DandelionWenjing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DandelionWenjing/subscriptions","organizations_url":"https://api.github.com/users/DandelionWenjing/orgs","repos_url":"https://api.github.com/users/DandelionWenjing/repos","events_url":"https://api.github.com/users/DandelionWenjing/events{/privacy}","received_events_url":"https://api.github.com/users/DandelionWenjing/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-11T03:35:23Z","updated_at":"2018-08-13T14:42:19Z","closed_at":null,"author_association":"NONE","body":"Hi all,\r\nI tried to use the Power BI to connect clickhouse odbc driver while met the following error:\r\n\r\nFeedback Type:\r\nFrown (Error)\r\n\r\nTimestamp:\r\n2018-07-12T06:23:06.6483545Z\r\n\r\nLocal Time:\r\n2018-07-12T14:23:06.6483545+08:00\r\n\r\nSession ID:\r\n4004306b-ba15-4bc7-966c-9c202418c1f6\r\n\r\nRelease:\r\nJune 2018\r\n\r\nProduct Version:\r\n2.59.5135.781 (PBIDesktop) (x64)\r\n\r\nError Message:\r\nOLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] HTTP status code: 500\r\nReceived error:\r\nCode: 62, e.displayText() = DB::Exception: Syntax error: failed at position 12 (line 1, col 12): 1000001\r\n    `TimeStamp`\r\nfrom `default`.`TrafficTable4`\r\ngroup by `TimeStamp`. Expected one of: identifier, alias, AS, token, AND, OR, UNION ALL, BETWEEN, IS, LIKE, NOT LIKE, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, Comma, Dot, Arrow, QuestionMark, ORDER BY, SETTINGS, INTO OUTFILE, FORMAT, FROM, PREWHERE, WHERE, WITH, HAVING, LIMIT, GROUP BY, e.what() = DB::Exception\r\n\r\nOS Version:\r\nMicrosoft Windows NT 10.0.17134.0 (x64 zh-CN)\r\n\r\nCLR Version:\r\n4.7 or later [Release Number = 461808]\r\n\r\nPeak Virtual Memory:\r\n38.2 GB\r\n\r\nPrivate Memory:\r\n329 MB\r\n\r\nPeak Working Set:\r\n466 MB\r\n\r\nIE Version:\r\n11.112.17134.0\r\n\r\nUser ID:\r\ndb8cee20-5c05-4896-8470-a1fa38cf1cee\r\n\r\nWorkbook Package Info:\r\n1* - zh-CN, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.\r\n\r\nTelemetry Enabled:\r\nTrue\r\n\r\nModel Default Mode:\r\nDirectQuery\r\n\r\nSnapshot Trace Logs:\r\nC:\\Users\\wenzhao\\AppData\\Local\\Microsoft\\Power BI Desktop\\FrownSnapShot977727484.zip\r\n\r\nPerformance Trace Logs:\r\nC:\\Users\\wenzhao\\AppData\\Local\\Microsoft\\Power BI Desktop\\PerformanceTraces.zip\r\n\r\nEnabled Preview Features:\r\nCustomConnectors\r\n\r\nDisabled Preview Features:\r\nPBI_shapeMapVisualEnabled\r\nPBI_EnableReportTheme\r\nPBI_newFromWeb\r\nPBI_SpanishLinguisticsEnabled\r\nPBI_qnaExplore\r\nPBI_variationUIChange\r\nPBI_canvasTooltips\r\nPBI_showIncrementalRefreshPolicy\r\n\r\nDisabled DirectQuery Options:\r\nPBI_DirectQuery_Unrestricted\r\nTreatHanaAsRelationalSource\r\n\r\nCloud:\r\nMSIT\r\n\r\nDPI Scale:\r\n100%\r\n\r\nSupported Services:\r\nPower BI\r\n\r\nFormulas:\r\n\r\n\r\nsection Section1;\r\n\r\nshared TrafficTable4 = let\r\n    Source = DirectCH.Database(\"ClickhouseA\"),\r\n    TrafficTable4_Table = Source{[Name=\"TrafficTable4\",Kind=\"Table\"]}[Data]\r\nin\r\n    TrafficTable4_Table;\r\n\r\nWenjing Zhao"},"comment":{"url":"https://api.github.com/repos/yandex/clickhouse-odbc/issues/comments/412542492","html_url":"https://github.com/yandex/clickhouse-odbc/issues/92#issuecomment-412542492","issue_url":"https://api.github.com/repos/yandex/clickhouse-odbc/issues/92","id":412542492,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMjU0MjQ5Mg==","user":{"login":"proller","id":1752192,"node_id":"MDQ6VXNlcjE3NTIxOTI=","avatar_url":"https://avatars0.githubusercontent.com/u/1752192?v=4","gravatar_id":"","url":"https://api.github.com/users/proller","html_url":"https://github.com/proller","followers_url":"https://api.github.com/users/proller/followers","following_url":"https://api.github.com/users/proller/following{/other_user}","gists_url":"https://api.github.com/users/proller/gists{/gist_id}","starred_url":"https://api.github.com/users/proller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/proller/subscriptions","organizations_url":"https://api.github.com/users/proller/orgs","repos_url":"https://api.github.com/users/proller/repos","events_url":"https://api.github.com/users/proller/events{/privacy}","received_events_url":"https://api.github.com/users/proller/received_events","type":"User","site_admin":false},"created_at":"2018-08-13T14:42:19Z","updated_at":"2018-08-13T14:42:19Z","author_association":"CONTRIBUTOR","body":"can you show full failed query?\r\nCode: 62, e.displayText() = DB::Exception: Syntax error: failed at position 12 (line 1, col 12): 1000001\r\nTimeStamp from default.TrafficTable4\r\n\r\nmaybe from clickhouse server logs ?"}}
{"actor":{"display_login":"proller"}}