Power BI 中的 SQL Server Analysis Services 即時資料SQL Server Analysis Services live data in Power BI

Power BI 有兩種方式可以連接到即時 SQL Server Analysis Services 伺服器。In Power BI, there are two ways you can connect to a live SQL Server Analysis Services server. 您可以在 [取得資料] 中連接至 SQL Server Analysis Services 伺服器,或者連接到 Power BI Desktop 檔案Excel 活頁簿 (該活頁簿已連接至 Analysis Services 伺服器)。In Get data, you can connect to a SQL Server Analysis Services server, or you can connect to a Power BI Desktop file, or Excel workbook, that already connects to an Analysis Services server.


  • 若要連線到即時 Analysis Services 伺服器,必須由系統管理員安裝及設定內部部署資料閘道。In order to connect to a live Analysis Services server, an on-premises data gateway must be installed and configured by an administrator. 如需詳細資訊,請參閱內部部署資料閘道For more information, see On-premises data gateway.
  • 使用閘道時,您的資料會保持內部部署。When you use the gateway, your data remains on-premises. 根據此資料建立的報表會儲存在 Power BI 服務中。The reports you create based on that data are saved in the Power BI service.
  • Analysis Services 即時連接的自然語言查詢問與答目前僅為預覽版。Q&A natural language querying is in preview for Analysis Services live connections.

從 [取得資料] 連接到模型To connect to a model from Get data

  1. 在 [我的工作區] 中,選取 [取得資料]。In My Workspace, select Get data. 您也可以變更為群組工作區 (如果有的話)。You can also change to a group workspace, if one is available.

  2. 選取 Databases & More (資料庫及更多).Select Databases & More.

  3. 按一下 [SQL Server Analysis Services] > [連接]。Select SQL Server Analysis Services > Connect.

  4. 選取伺服器。Select a server. 如果您看不到此處列有任何伺服器,則表示未設定閘道和資料來源,或是您的帳戶未列於閘道中之資料來源的 [使用者] 索引標籤中。If you don't see any servers listed here, it means either a gateway, and data source, are not configured, or your account is not listed in the Users tab of the data source, in the gateway. 請洽詢系統管理員。Check with your adminsitrator.
  5. 選取您要連接的模型。Select the model you want to connect to. 可以是表格式或多維度。This could be either Tabular or Multidimensional.

連接到模型之後,它會顯示在 Power BI 站台的 [我的工作區/資料集] 。After you connect to the model, it will appear in your Power BI site in My Workspace/Datasets. 如果您切換到群組工作區,則會在該群組內出現資料集。If you were swtiched to a group workspace, then the dataset will appear within the group.

儀表板圖格Dashboard tiles

報表的視覺效果如果釘選到儀表板,釘選的磚會每 10 分鐘自動重新整理一次。If you pin visuals from a report to the dashboard, the pinned tiles are automatically refreshed every 10 minutes. 如果更新內部部署 Analysis Services 伺服器中的資料,磚會在 10 分鐘後自動更新。If the data in your on-premises Analysis Services server is updated, the tiles will get auto-updated after 10 minutes.

後續步驟Next steps

內部部署資料閘道On-premises data gateway
管理 Analysis Services 資料來源Manage Analysis Services data sources
為內部部署資料閘道進行疑難排解Troubleshooting the on-premises data gateway
有其他問題嗎?More questions? 試試 Power BI 社群Try the Power BI Community