Power BI 中的連接器擴充性Connector extensibility in Power BI

Power BI 可使用現有的連接器和一般資料來源 (例如 ODBC、OData、OLE DB、Web、CSV、XML 和 JSON) 連線至資料。Power BI can connect to data by using existing connectors and generic data sources, like ODBC, OData, OLE DB, Web, CSV, XML, and JSON. 或者,開發人員可使用名為 自訂連接器 的自訂資料延伸模組來啟用新的資料來源。Or, developers can enable new data sources with custom data extensions called custom connectors. 某些自訂連接器已通過 Microsoft 的認證並以 經認證的連接器 的形式散發。Some custom connectors are certified and distributed by Microsoft as certified connectors.

若要使用由您或第三方開發、但未經認證的自訂連接器,您必須調整 Power BI Desktop 安全性設定,以允許在沒有驗證或警告的情況下載入延伸模組。To use non-certified custom connectors that you or a third party have developed, you must adjust the Power BI Desktop security settings to allow extensions to load without validation or warning. 由於此程式碼可處理認證 (包括透過 HTTP 加以傳送),且會忽略隱私權層級,因此,只有在您絕對信任自訂連接器時,才應使用此安全性設定。Because this code can handle credentials, including sending them over HTTP, and ignore privacy levels, you should only use this security setting if you absolutely trust your custom connectors.

另一個選項是讓開發人員以憑證簽署連接器,並提供讓您直接加以使用而無須變更安全性設定時所需的資訊。Another option is for the developer to sign the connector with a certificate, and provide the information you need to use it without changing your security settings. 如需詳細資訊,請參閱關於受信任的第三方連接器For more information, see About trusted third-party connectors.

自訂連接器Custom connectors

未經認證的自訂連接器種類繁多,從小型商務關鍵性 API,到 Microsoft 尚未發行連接器的大型產業特定服務,都包含在內。Non-certified custom connectors can range from small business-critical APIs to large industry-specific services that Microsoft hasn't released a connector for. 廠商也會散發許多連接器。Many connectors are distributed by vendors. 如果您需要特定的資料連線器,請洽詢廠商。If you need a specific data connector, contact the vendor.

若要使用未經認證的自訂連接器,請將連接器的 .pq.pqx.m.mez 檔案放置在 [Documents]\Power BI Desktop\Custom Connectors 資料夾中。To use a non-certified custom connector, put the connector .pq, .pqx, .m, or .mez file in the [Documents]\Power BI Desktop\Custom Connectors folder. 如果該資料夾不存在,請予以建立。If the folder doesn't exist, create it.

請依照下列方式調整資料延伸模組安全性設定:Adjust the data extension security settings as follows:

在 Power BI Desktop 中,選取 [檔案] > [選項及設定] > [選項] > [安全性] 。In Power BI Desktop, select File > Options and settings > Options > Security.

在 [資料延伸模組] 底下,選取 [(不建議) 允許任何延伸模組載入,而不經過驗證或警告] 。Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning. 選取 [確定] ,然後重新啟動 Power BI Desktop。Select OK, and then restart Power BI Desktop.


預設 Power BI Desktop 資料延伸模組安全性設定為 [(建議使用) 只允許經過 Microsoft 認證和其他信任的第三方延伸模組載入] 。The default Power BI Desktop data extension security setting is (Recommended) Only allow Microsoft certified and other trusted third-party extensions to load. 使用此設定時,如果您的系統上有未經認證的自訂連接器,在 Power BI Desktop 啟動時就會出現 [未經認證的連接器] 對話方塊,並列出無法安全載入的連接器。With this setting, if there are non-certified custom connectors on your system, the Uncertified Connectors dialog box appears at Power BI Desktop startup, listing the connectors that can't securely load.


若要解決此錯誤,您可以變更 [資料延伸模組] 安全性設定,或從 Custom Connectors 資料夾中移除未經認證的連接器。To resolve the error, you can either change your Data Extensions security setting, or remove the uncertified connectors from your Custom Connectors folder.

認證的連接器Certified connectors

有少部分的資料延伸模組會被視為 經過認證 的延伸模組。A limited subset of data extensions is considered certified. 雖然 Microsoft 會散發這些連接器,但 Microsoft 不會負責其效能或功能的持續性。While Microsoft distributes the connectors, it's not responsible for their performance or continued function. 建立連接器的第三方開發人員需負責其維護和支援。The third-party developer who created the connector is responsible for its maintenance and support.

在 Power BI Desktop 中,經過認證的第三方連接器會出現在 [取得資料] 對話方塊中的清單上,與一般和通用連接器一併顯示。In Power BI Desktop, certified third-party connectors appear in the list in the Get Data dialog box, along with generic and common connectors. 您無須調整安全性設定即可使用經過認證的連接器。You don't need to adjust security settings to use the certified connectors.

如果您想要認證自訂連接器,請要求您的廠商連絡 dataconnectors@microsoft.com。If you would like a custom connector to be certified, ask your vendor to contact dataconnectors@microsoft.com.