參考文檔:https://docs.microsoft.com/zh-tw/power-query/connectors/odbc
https://www.cnblogs.com/shanyaohui/p/14106869.html
第一步:為數(shù)據(jù)源安裝 ODBC 驅(qū)動(dòng)程序并配置 ODBC 數(shù)據(jù)源
1.? 要先下一個(gè) c++ 的包
下載地址參考:
Visual C++ Redistributable for Visual Studio 2013 installed (with the same bitness as the driver that you are installing).
You can download the installation packages athttps://www.microsoft.com/en-ca/download/details.aspx?id=40784
下載界面:
2.下載 ODBC impala 驅(qū)動(dòng)
下載地址:https://www.cloudera.com/downloads/connectors/impala/odbc/2-5-36.html
3.在電腦上搜索 ODBC ,以管理員身份打開 ODBC 數(shù)據(jù)源
為多個(gè)用戶創(chuàng)建系統(tǒng) DSN,點(diǎn)擊添加:
選擇 odbc driver for impala:
配置一下:
測試成功后,一路點(diǎn)擊"OK"
現(xiàn)在我們已經(jīng)創(chuàng)建好了 sensorsdata 數(shù)據(jù)庫 DSN
第二步:從 Power BI Desktop 連接到 ODBC 源
參考下圖進(jìn)行連接查詢: