啟用即時連線的問與答Enable Q&A for live connections

什麼是內部部署資料閘道?What is on-premises data gateway? 什麼是即時連線?What is a live connection?

Power BI 中的資料集可匯入 Power BI,或者您可以建立與資料集的即時連接。Datasets in Power BI can be imported into Power BI or you can create a live connection to them. 即時連接的資料集通常稱為「內部部署」。Live connection datasets are often referred to as "on-premises". 您可以使用閘道管理即時連線,並使用即時查詢以來回傳送資料及查詢。The live connections are managed using a gateway and data and inquiries are sent back and forth using live queries.

內部部署資料閘道資料集問與答Q&A for on-premises data gateway datasets

如果您想要搭配透過閘道存取的資料集使用問與答,必須先啟用資料集。If you'd like to use Q&A with datasets you access through a gateway, you'll need to enable them first.

啟用之後,Power BI 會建立資料來源的索引,並將該資料子集上傳到 Power BI,以允許詢問問題。Once enabled, Power BI creates an index of your data source and uploads a subset of that data to Power BI to enable asking questions. 建立初始索引可能需要幾分鐘的時間,Power BI 會維護索引並隨著您的資料變更自動更新索引。It may take several minutes to create the initial index and Power BI maintains and updates the index automatically as your data changes. 搭配這些資料集使用問與答與將資料發佈到 Power BI 的行為相同。Using Q&A with these datasets behaves the same as with data published to Power BI. 這兩種情況都支援問與答體驗中可用的完整功能集,包括搭配 Cortana 使用資料來源。The full set of features available in the Q&A experience is supported in both cases, including using the data source with Cortana.

當您在 Power BI 中詢問問題時,問與答會使用資料集的索引,來判斷要建構的最佳視覺效果,或用來回答問題的報表工作表。As you ask questions in Power BI, Q&A determines the best visual to construct or report sheet to use to answer your question using an index of your dataset. 判斷可能的最佳答案之後,問與答會使用 DirectQuery 透過閘道從資料來源擷取即時資料,來填入圖表和圖形。After determining the best potential answer, Q&A uses DirectQuery to fetch live data from the data source via the gateway to populate charts and graphs. 這可確保 Power BI 問與答結果一律會直接從基礎資料來源顯示最新資料。This ensures Power BI Q&A results always show the most up-to-date data directly from the underlying data source.

因為 Power BI 問與答使用資料來源中的文字和結構描述值,來判斷如何查詢基礎模型以取得答案,所以搜尋特定的新文字值或已刪除的文字值 (例如詢問與新加入之文字記錄相關的客戶名稱) 需要以最新值更新索引。Since Power BI Q&A uses the text and schema values from your data source to determine how to query the underlying model for answers, searches for specific new or deleted text values (such as asking for a customer name related to a newly added text record) rely on the index being up-to-date with the latest values. Power BI 會在變更後的 60 分鐘內自動更新文字和結構描述索引。Power BI automatically keeps the text and schema index up to date within a 60 minute window of changes.

如需詳細資訊,請參閱:For more information, see:

啟用問與答Enable Q&A

設定資料閘道之後,從 Power BI 連線到您的資料。Once you have the data gateway set up, connect to your data from Power BI. 您可以使用內部部署資料建立儀表板,或上傳使用內部部署資料的 .pbix 檔案。Either create a dashboard using your on-premises data, or upload a .pbix file that uses on-premises data. 您也可能在與您共用的儀表板、報表和資料集中已有內部部署資料。You may also already have on-premises data in dashboards, reports, and datasets that have been shared with you.

  1. 選取 Power BI 右上角的齒輪圖示 ,然後選擇 [設定]。In the upper-right corner of Power BI, select the cog icon and choose Settings.

  2. 選取 [資料集],然後選擇資料集以啟用問與答。Select datasets and choose the dataset to enable for Q&A.

  3. 展開 [Q&A and Cortana] (問與答及 Cortana),選取 [Turn on Q&A for this dataset] (在此資料集開啟問與答) 核取方塊,然後選擇 [套用]。Expand Q&A and Cortana, select the checkbox for Turn on Q&A for this dataset and choose Apply.

會快取哪些資料,以及如何保護隱私權?What data is cached and how is privacy protected?

當您啟用內部部署資料的問與答時,會快取服務中的資料子集。When you enable Q&A for your on-premises data, a subset of your data is cached in the service. 這樣做是為了確保問與答的執行效能最理想。This is done to ensure that Q&A works with a reasonable performance. 我們會從快取中排除長度超過 24 個字元的值。We exclude values longer than 24 characters from caching. 當您取消核取 [Turn on Q&A for this dataset] (在此資料集開啟問與答) 來停用問與答或在刪除資料集時,快取會在幾小時內刪除。The cache is deleted within a few hours when you disable Q&A by unchecking Turn on Q&A for this dataset, or when you delete your dataset.

考量與疑難排解Considerations and troubleshooting

此功能的預覽階段期間有幾項限制︰During the Preview phase of this feature, there are several limitations:

  • 一開始,此功能僅適用於 SQL Server 2016 Analysis Services 表格式資料來源。Initially the feature is only available for SQL Server 2016 Analysis Services Tabular data sources. 此功能已最佳化,現在可使用表格式資料。The feature is optimized to work with tabular data. 某些功能適用於多維度資料來源,但多維度尚未支援完整的問與答體驗。Some functionality is available for multi-dimensional data sources, but the full Q&A experience is not yet supported for multi-dimensional. 內部部署資料閘道支援的其他資料來源將於公開預覽期間推出。Additional data sources supported by the on-premises data gateway will be rolled out during the public preview.
  • 公開預覽一開始並未完整支援 SQL Server Analysis Services 中定義的資料列層級安全性。Full support for row level security defined in SQL Server Analysis Services is not available initially in the public preview. 在問與答中詢問問題時,輸入問題後的「自動完成」功能可顯示使用者無權存取的字串值。While asking questions in Q&A, the “auto-complete” of questions while typing can show string values a user does not have access to. 不過,報表和圖表視覺效果會使用模型中定義的 RLS,因此不會公開任何基礎數值資料。However, RLS defined in the model is respected for report and chart visuals so no underlying numerical data can be exposed. 未來更新將會發行控制此行為的選項。Options to control this behavior will be released in coming updates.
  • 只有內部部署資料閘道支援即時連線。Live connections are only supported with the on-premises data gateway. 因此,這無法用於個人閘道器。As a result, this cannot be used with the personal gateway.

後續步驟Next steps

內部部署資料閘道On-premises data gateway
管理您的資料來源─Analysis ServicesManage your data source - Analysis Services
Power BI 深入資訊摘要Power BI Quick Insights
針對 Power BI 深入資訊摘要將資料最佳化Optimize your data for Power BI Quick Insights
Power BI - 基本概念Power BI - Basic Concepts
Power BI 中的儀表板Dashboards in Power BI

有其他問題嗎?More questions? 嘗試在 Power BI 社群提問Try asking the Power BI Community