Power BI Desktop 的先前每月更新Previous monthly updates to Power BI Desktop

本文說明 Power BI Desktop 的先前更新。This article describes previous updates to Power BI Desktop. 如需最新月份的版本,請參閱 Power BI Desktop 最新更新For the most current month's release, check out Power BI Desktop latest updates.

下列章節說明 Power BI Desktop 前幾個月的更新。The following sections describe previous months' updates to Power BI Desktop.

您一律可以下載最新版本的 Power BI DesktopYou can always download the latest version of Power BI Desktop. 如果您執行 Windows 10,您也可以從 Windows 市集取得 Power BI DesktopIf you're running Windows 10, you can also get Power BI Desktop from the Windows Store. 不論您使用哪種方式安裝 Power BI Desktop,每月的版本都相同。The monthly versions are the same, regardless of which way you install Power BI Desktop. 如需詳細資訊,請參閱本文See this article for more information.

2017 年 11 月更新 (2.52.4921.202)November 2017 Update (2.52.4921.202)

12 月有 Power BI Desktop 更新的整個蒐集價值。November brought a whole harvest worth of updates to Power BI Desktop.

旁邊的連結分別更新下列項目:The links beside each update mean the following:

  • 討論到某功能時,[影片] 會在新的瀏覽器分頁中摘錄片段。[video] excerpts play in a new browser tab, when the feature is being discussed.
  • 某些功能有 [文章] 提供詳細資料。Some features have an [article] that provides more detail.
  • 每月更新的 [部落格] 文章中則說明大多數功能。Most features are explained in the monthly update [blog] post.
  • 最後,有些功能一目瞭然,因此不需要文章或影片。Lastly, some features are self-explanatory and don't need and article or video.

您也可以從頭開始觀賞 [最新更新] 視訊 (位於本文中),方法是按一下更新清單下方視訊影像的 [播放] 圖示。You can also watch the Latest Updates video from the beginning, right inside this article, by clicking on the play icon on the video image found below the list of updates.

以下是本月 Power BI Desktop 新增的更新:The following updates are new to Power BI Desktop this month:

報告Reporting

分析Analytics

  • 多列卡片之多維度 AS 模型的資料格層級格式 [影片] [部落格]Cell-level formatting for multidimensional AS models for multi-row card [video] [blog]

資料連線Data connectivity

其他Other

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中的部落格文章參考相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 10 月更新 (2.51.4885.543)October 2017 Update (2.51.4885.543)

10 月更新為 Power BI Desktop 提供一組相當吸引人的實用更新。October brought a frighteningly compelling group of useful updates to Power BI Desktop.

旁邊的連結分別更新下列項目:The links beside each update mean the following:

  • 討論到某功能時,[影片] 會在新的瀏覽器分頁中摘錄片段。[video] excerpts play in a new browser tab, when the feature is being discussed.
  • 某些功能有 [文章] 提供詳細資料。Some features have an [article] that provides more detail.
  • 每月更新的 [部落格] 文章中則說明大多數功能。Most features are explained in the monthly update [blog] post.
  • 最後,有些功能一目瞭然,因此不需要文章或影片。Lastly, some features are self-explanatory and don't need and article or video.

您也可以從頭開始觀賞 [最新更新] 視訊 (位於本文中),方法是按一下更新清單下方視訊影像的 [播放] 圖示。You can also watch the Latest Updates video from the beginning, right inside this article, by clicking on the play icon on the video image found below the list of updates.

以下是本月 Power BI Desktop 新增的更新:The following updates are new to Power BI Desktop this month:

報告:Reporting:

分析:Analytics:

資料連接:Data Connectivity:

其他:Other:

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中的部落格文章參考相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 9 月更新 (2.50.4859.502)September 2017 Update (2.50.4859.502)

以下是 9 月 Power BI Desktop 新增的更新:The following updates are new to Power BI Desktop in September:

報表檢視:Report View:

資料連接:Data Connectivity:

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中的部落格文章參考相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 8 月更新 (2.49.4831.222)August 2017 Update (2.49.4831.222)

以下是 8 月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in August:

報表檢視:Report View:

分析和模型化:Analytics & Modeling:

資料連接:Data Connectivity:

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中的部落格文章參考相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 7 月更新 (2.48.4792.321)July 2017 Update (2.48.4792.321)

以下是 7 月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in July:

報表檢視:Report View:

分析和模型化:Analytics & Modeling:

資料連接:Data Connectivity:

查詢編輯:Query Editing:

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中的部落格文章參考相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 6 月更新 (2.47.4766.542)June 2017 Update (2.47.4766.542)

以下是 6 月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in June:

報表檢視:Report View:

資料連接:Data Connectivity:

查詢編輯:Query Editing:

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 5 月更新 (2.46.4732.461)May 2017 Update (2.46.4732.461)

以下是 5 月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in May:

報表檢視:Report View:

分析:Analytics:

資料連接:Data Connectivity:

查詢編輯:Query Editing:

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 4 月更新 (2.45.4704.442)April 2017 Update (2.45.4704.442)

以下是 2017 年 4 月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in April 2017:

報表檢視:Report View:

分析:Analytics:

資料連接:Data Connectivity:

查詢編輯:Query Editing:

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 3 月更新 (2.44.4675.422)March 2017 Update (2.44.4675.422)

以下是 2017 年 3 月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in March 2017:

報表檢視:Report View:

分析:Analytics:

資料連接:Data Connectivity:

  • 新增或增強型資料連接器 [影片]New or enhanced data connectors [video]:

查詢編輯器改進Query Editing improvements

  • 依分隔符號分割資料行 - 自動偵測分隔符號字元 [影片] [部落格]Split column by delimiter - automatic detection of delimiter character [video] [blog]

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 2 月的更新 (2.43.4647.541)February 2017 Update (2.43.4647.541)

以下是 2 月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in February:

報表檢視:Report View:

分析:Analytics:

  • 兩個新的快速計算︰資料列總數的百分比與資料行總計的百分比 [視訊] [部落格]Two new Quick Calcs: Percent of row total, and percent of column total [video] [blog]

資料連接:Data Connectivity:

  • 新增或增強型資料連接器 [影片]New or enhanced data connectors [video]:
    • ODBC 與 OLE DB 連接器 - 支援選取相關的資料表 [部落格]ODBC and OLE DB connectors - support for Select related tables [blog]
    • 增強資料夾連接器 - 支援合併 [預覽] 對話方塊中的二進位檔 [視訊] [部落格]Enhanced Folder connector - support for combining binaries from the Preview dialog [video] [blog]
    • 結合文字與 CSV 連接器 [視訊] [部落格]Unified Text and CSV connectors [video] [blog]
    • 新功能 - PowerApps Common Data Service 連接器 [部落格]New - PowerApps Common Data Service connector [blog]

查詢編輯器改進Query Editing improvements

  • 新的 [Column headers type] (資料行標頭類型) 功能表中的 [使用地區設定] 選項可快速變更資料行的資料類型及地區設定 [視訊] [部落格]Quickly change a column's data type and locale with the new Using locale option in the Column headers type menu [video] [blog]
  • 使用新的 [在此項目後插入步驟:] 選項可輕鬆在現有的查詢中插入步驟 [視訊] [部落格]Easily insert steps into existing queries, using the new Insert Step After option [video] [blog]

其他功能改進Other improvements

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2017 年 1 月更新 (2.42.4611.482)January 2017 Update (2.42.4611.482)

以下是 Power BI Desktop 一月份新增的更新:The following updates are new to Power BI Desktop in January:

報表檢視:Report View:

資料連接器︰Data Connectors:

查詢編輯器改進Query Editing improvements

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 11 月更新 (2.41.4581.301)November 2016 Update (2.41.4581.301)

以下是十一月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in November:

報表檢視:Report View:

分析Analytics

資料連接器︰Data Connectors:

查詢編輯器改進Query Editing improvements

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 10 月更新 (2.40.4554.361)October 2016 Update (2.40.4554.361)

以下是十月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in October:

報表檢視:Report View:

分析Analytics

資料連接器︰Data Connectors:

查詢編輯器改進Query Editing improvements

其他功能改進Other improvements

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 9 月更新 (2.39.4526.362)September 2016 Update (2.39.4526.362)

以下是九月 Power BI Desktop 新增的更新:The following updates were new to Power BI Desktop in September:

報表檢視:Report View:

分析Analytics

資料連接器︰Data Connectors:

  • 新的資料連接器︰New data connectors:
  • 改進現有的連接器︰Improvements to existing connectors:
    • Oracle 連接器 - 改善的 Navigator 預覽效能 [部落格]Oracle connector - improved Navigator previews performance [blog]
    • OData 連接器 - 支援 [選取的相關資料表] 選項 [部落格]OData connector - support for Select Related Tables option [blog]
    • SAP 商務倉儲和 SAP HANA 連接器 - 參數輸入介面的增強功能 [文章] [部落格]SAP Business Warehouse and SAP HANA connectors - enhancements to parameter input interface [article] [blog]
    • Web 連接器 - 在對話方塊內指定 HTTP 要求標頭的支援 [部落格] [視訊]Web connector - support for specifying HTTP request headers within the dialog [blog] [video]

查詢編輯器改進:Query Editor improvements:

  • 查詢相依性檢視 [部落格] [視訊]Query Dependencies view [blog] [video]
  • 顯示錯誤體驗 [部落格]Show Errors experience [blog]
  • 純量值的查詢編輯器功能區支援 [部落格]Query Editor ribbon support for scalar values [blog]
  • 新增函式引動過程資料行 [部落格]Add function invocation column [blog]
  • 展開和彙總資料行 - 支援 [載入更多] 值[部落格]Expand & Aggregate columns - support for Load More values [blog]
  • 新轉換 - 將資料表資料行轉換為清單 [部落格]New transform - convert Table Column to a list [blog]
  • 鍵盤輸入 - 支援下拉式功能表中的 [智慧輸入] [部落格]Keyboarding - support for smart typing in drop-down menus [blog]

其他功能改進Other improvements

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 8 月更新 (2.37.4464.321)August 2016 Update (2.37.4464.321)

我們在 8 月為 Power BI Desktop 引進了大量新功能:August introduced a full harvest of new features for Power BI Desktop:

  • 討論到某功能時,[影片] 會在新的瀏覽器分頁中摘錄片段。[video] excerpts play in a new browser tab, when the feature is being discussed.
  • 某些功能有 [文章] 提供詳細資料。Some features have an [article] that provides more detail.
  • 每月更新的 [部落格] 文章中則說明大多數功能。Most features are explained in the monthly update [blog] post.
  • 最後,有些功能一目瞭然,因此不需要文章或影片。Lastly, some features are self-explanatory and don't need and article or video.

您也可以從頭開始觀賞 [最新更新] 視訊 (位於本文中),方法是按一下更新清單下方視訊影像的 [播放] 圖示。You can also watch the Latest Updates video from the beginning, right inside this article, by clicking on the play icon on the video image found below the list of updates.

以下是本月 Power BI Desktop 新增的更新:The following updates are new to Power BI Desktop this month:

報表檢視:Report View:

分析 (新功能!)Analytics (New!)

資料連接器︰Data Connectors:

查詢編輯器改進:Query Editor improvements:

其他功能改進Other improvements

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 7 月更新 (2.37.4464.321)July 2016 Update (2.37.4464.321)

您一律可以下載最新版本的 Power BI DesktopYou can always download the latest version of Power BI Desktop.

7 月另有一系列優異的新功能,以及備受期待的 Power BI 資料連接器。July brought another great collection of new features and highly anticipated data connectors to Power BI Desktop. 下列增強功能是 7 月 Power BI Desktop 的新功能:The following enhancements were new to Power BI Desktop in July:

報表檢視:Report View:

資料連接器︰Data Connectors:

查詢編輯器改進:Query Editor improvements:

  • 在查詢編輯器中使用 R 指令碼 [文章] [部落格]Use R script in Query Editor [article] [blog]
  • 加強查詢參數︰Query parameter enhancements:
    • 將查詢輸出列為參數「允許的值」[部落格]List query output as allowed values for a parameter [blog]
  • 覆寫現有的使用者定義函數 [部落格]Overwrite existing user-defined functions [blog]

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項功能的詳細資訊 (這和上列清單中參考的部落格文章相同)。Take a look at the blog post, where you can get more detailed information about each of these features (this is the same blog post referenced in the list above).

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 6 月更新 (2.36.4434.362)June 2016 Update (2.36.4434.362)

您一律可以下載最新版本的 Power BI DesktopYou can always download the latest version of Power BI Desktop.

我們在 6 月提供了一系列嶄新又有趣的 Power BI Desktop 更新。June provided a shining collection of interesting updates for Power BI Desktop.

報表檢視:Report View:

資料存取︰Data Access:

資料連接器︰Data Connectors:

  • 新的資料連接器︰[部落格]New data connector: [blog]
    • Azure 企業版Azure Enterprise
  • 增強的 SAP BW 和 HANA 連接器︰ [部落格]Enhanced SAP BW and HANA connectors: [blog]
    • 允許變數/參數值的多重選取Allow multi-select of values for Variables/Parameters
    • 支援 SAP BW 中的階層Support for Hierarchies in SAP BW
  • 增強的 OData 連接器 - 匯入 Open Type 資料行 [部落格]Enhanced OData connector - imports Open Type columns [blog]
  • 增強的 Access DB 連接器 - [導覽] 對話方塊中的 [選取相關資料表] 按鈕 [部落格]Enhanced Access DB connector - button to Select Related Tables in Navigator dialog [blog]

資料連接器︰Data Connectors:

  • 範本 - [載入] 或 [編輯] 的選項 [部落格]Templates - option to Load or Edit [blog]
  • 查詢參數的功能加強︰[部落格]Query parameter enhancements: [blog]
    • 一律允許參數規格的選項Option to always allow Parameter specification
    • 直接在內容中建立新的參數Create new parameter directly in context
  • 以英文產生步驟名稱的選項 [部落格]Option to generate Step Names in English [blog]
  • 查詢步驟的說明 [視訊] [部落格]Descriptions for Query Steps [video] [blog]
  • 新的資料轉換︰[部落格]New Data Transformations: [blog]
    • 從 DateTime 資料行中擷取週、日期及月份名稱Extract Week Day and Month Name from a DateTime column
    • 將日期和時間合併到 DateTime 資料行Merging dates and Times into a DateTime column
    • 擷取 Time.Start/結束小時/分鐘/秒Extract Time.Start/End of Hour/Minute/Second

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2015 年 5 月更新 (2.23.4036.161)May 2016 Update (2.35.4399.381)

您一律可以下載最新版本的 Power BI DesktopYou can always download the latest version of Power BI Desktop.

可能會引進另一個更引人注目的 Power BI Desktop 大型更新集合。May brought another large collection of compelling updates for Power BI Desktop:

報表檢視:Report View:

分析Analytics

資料連接:Data Connectivity:

  • 新的資料連接器︰[部落格]New data connectors: [blog]
    • InformixInformix
    • comScore Digital AnalytixcomScore Digital Analytix
    • TrouxTroux
    • Planview EnterprisePlanview Enterprise
  • 改善的 DB2 連接器 [部落格]Improved DB2 connector [blog]
  • Text/CSV 連接器會在預覽對話方塊中公開可編輯設定 [部落格]Text/CSV connector exposes editable settings in preview dialog [blog]
  • 使用顯示結構描述資訊改善的關聯式資料庫連接器Improved relational database connectors with Display Schema information
  • 資料來源設定增強功能 [部落格]Data Source Settings enhancements [blog]
  • 進階的 [篩選資料列] 對話方塊模式 [部落格]Advanced Filter Rows dialog mode [blog]
  • 查詢編輯器中函式引動過程的內嵌輸入控制項 [部落格]Inline Input controls for Function invocation within Query Editor [blog]
  • 查詢參數︰[部落格]Query Parameters: [blog]
    • 轉換查詢至參數的能力 (反之亦然)Ability to convert queries to parameters (and vice versa)
    • 支援 Web 連接器中的 URL 參數化和多部分 URLSupport for URL parameterization and multi-part URLs in Web connector
    • 支援 [條件式資料行] 對話方塊中的參數化Support for parameterization in Conditional Columns dialog
  • 能夠 [另存新檔] Power BI 範本 [部落格]Ability to Save As a Power BI Template [blog]
  • 使用拖放支援重新排序查詢步驟 [部落格]Support for reordering Query Steps using drag-and-drop [blog]
  • [條件式資料行] 對話方塊輸入日期欄位中的日期選擇器支援 [部落格]Date picker support in Conditional Columns dialog input Date fields [blog]
  • 從 [查詢] 窗格中用來建立新查詢的新內容功能表項目 [部落格]New context menu entry to create new queries from the Queries pane [blog]

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 4 月更新 (2.34.4372.322)April 2016 Update (2.34.4372.322)

您一律可以下載最新版本的 Power BI DesktopYou can always download the latest version of Power BI Desktop.

我們在 4 月已提供給 Power BI 客戶另一組絕佳的 Power BI Desktop 更新。In April, we showered our great Power BI customers with another collection of compelling updates for Power BI Desktop. 下列增強功能是本月 Power BI Desktop 的新功能:The following enhancements are new to Power BI Desktop this month:

報表檢視:Report View:

  • 更多的資料表、矩陣和多列卡片的其他樣式Additional styles on a table, matrix, and multi-row card
  • 單一視覺效果的趨勢線Trend lines on single visuals
  • 新的鑽研動作:查看記錄New drill action – See Records
  • 鑽研/篩選時對應自動縮放Map auto-zoom during drill/filter
  • 已展開檢視的內嵌階層標籤 (預覽 - 請參閱文章)In-line hierarchy labels for expanded view (Preview - see the article)

資料模型化:Data Modeling:

  • 重新整理視覺效果時不會再封鎖模型化作業Modelling operations are no longer blocked while visuals are refreshing
  • 內建日期階層欄位的時間智慧 (預覽)Time Intelligence with built-in date hierarchy fields (Preview)
  • 資料模型的同義字Data model synonyms

資料連接:Data Connectivity:

  • 查詢參數Query Parameters
  • Power BI 範本檔案Power BI Template files
  • [取得資料] 對話方塊中的新 [線上服務] 類別New Online Services category in Get Data dialog
  • 新的連接器:New Connectors:
    • SharePoint 資料夾SharePoint Folder
    • WebtrendsWebtrends
    • SparkPostSparkPost
    • tyGraphtyGraph
  • 條件式資料行Conditional Columns
  • DirectQuery – 指定 DirectQuery 和資料來源對話方塊中的匯入模式DirectQuery – Specify DirectQuery vs. Import mode in data source dialogs
  • 查詢編輯器預覽資料行標頭的資料行類型指標Column type indicator in Query Editor preview column headers
  • 使用拖放手勢重新排序查詢和查詢群組Reorder Queries and Query Groups using Drag & Drop gestures
  • 功能區中的查詢管理功能表Query Management menu in the ribbon

注意

您也可以查看 Power BI Desktop 的所有可用資料來源,我們的資料來源會持續增加,因此請經常回來查看。You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 3 月更新 (2.33.4337.281)March 2016 Update (2.33.4337.281)

您現在可以下載最新版本的 Power BI DesktopYou can now download the latest version of Power BI Desktop.

我們在 3 月帶來各式各樣的更新和全新項目,包括另一組 Power BI Desktop 新增項目。March brings all sorts of renewal and freshness, including another round of Power BI Desktop additions. 下列增強功能是本月 Power BI Desktop 的新功能:The following enhancements are new to Power BI Desktop this month:

報表檢視:Report View:

  • 將報表發佈至 Power BI 服務的群組空間Publish reports to a Group Space in the Power BI service
  • 使用 KPI 趨勢的報表現在採用 SSAS MD 的 [不摘要] 模型設定Reports with KPI trends now respect Do Not Summarize model settings from SSAS MD
  • 資料點警告現在不會造成干擾Data Point warnings are now non-intrusive

資料模型化:Data Modeling:

  • 您現在可以在使用 DirectQuery 模式時,變更資料行的資料類型You can now change the data type of a column when using DirectQuery mode
  • 能夠針對 DirectQuery 中已匯入及建立的關聯性,採用參考完整性Ability to assume Referential Integrity on relationships (for those imported, and created) in DirectQuery
  • Oracle 與 Teradata 的 DirectQuery 現在是 Power BI Desktop 的一部分 (不再是預覽功能)DirectQuery for Oracle and Teradata is now part of Power BI Desktop (no long a preview feature)

資料連接:Data Connectivity:

  • 新的 SAP BW 連接器 (預覽功能)A new SAP BW Connector (preview feature)
  • 支援使用者介面 (UI) 中的命令逾時Support for Command Timeout in the user interface (UI)
  • 沒有可在電腦層級停用隱私權等級提示 (包括登錄機碼) 的設定There's a setting available to disable Privacy Level prompts at the machine level (including a registry key)
  • 查詢群組管理增強功能︰Query Group Management enhancements:
    • 全部展開/摺疊Expand/Collapse All
    • 保留查詢群組展開狀態Retain Query Group expansion state
  • 新的轉換:New Transformations:
    • 使用 [資料行篩選] 功能表移除空白Remove Blanks using the Column Filter menu
    • 將工期值轉換成年Convert Duration values to Years
    • 保留重複項目Keep Duplicates
  • 支援查詢編輯器預覽中的空白字元和換行字元Support for whitespace and line feeds in Query Editor preview
  • 在 [變更含地區設定的類型] 對話方塊中包含「範例輸入值」的提示Include hints for sample input values in the Change Type with Locale dialog
  • [導覽] 視窗的增強功能:Enhancements to the Navigator window:
    • 新增結構描述資訊至 ODBC 來源的導覽階層Add schema information to navigation hierarchy for ODBC sources
    • 能夠從 [導覽] 停用預覽Ability to disable preview from Navigator
    • 技術名稱支援Technical name support
  • 可釐清衝突的資料行名稱 (不區分大小寫的比較) 的自動載入步驟Load: Auto-step to disambiguate conflicting column names (case-insensitive comparison)
  • 您現在可以直接從 [查詢] 窗格重新命名查詢You can now rename queries directly from the Queries pane

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 2 月更新 (2.32.4307.362)February 2016 Update (2.32.4307.362)

您現在可以下載最新版本的 Power BI DesktopYou can now download the latest version of Power BI Desktop.

這個月,我們大幅新增了更多更新!We're leaping ahead with more updates this month! 這個二月有 29 天 (今年是閏年),而這個月也有 29 項 Power BI Desktop 每月更新。February brings 29 days to the month (it's a leap year), and with it, 29 improvements to this monthly update of Power BI Desktop. 下列增強功能是本月 Power BI Desktop 的新功能:The following enhancements are new to Power BI Desktop this month:

報表檢視:Report View:

  • 查看視覺效果背後的資料 (包括將資料匯出至 CSV )See Data Behind a Visual (including Export Data to CSV)
  • 地圖改進 – 只以經緯度繪製地圖Map improvements – plot map with latitude/longitude only
  • KPI 耗用量版本支援 (包括 SSAS MD 的瀏覽階層支援及 KPI 趨勢)KPI consumption release support (including navigation hierarchy support and KPI trend for SSAS MD)
  • SSAS 探勘模式:支援 [欄位] 窗格中的 [顯示] 資料夾SSAS Exploration Mode: Support for Display folders in the Fields pane
  • 功能區配置改進:[報表工具] 的內容功能區索引標籤Ribbon layout improvements: Contextual ribbon tab for Report Tools
  • 新的 KPI 視覺效果New KPI visual
  • 在儲存報表時,取得開啟至可見之相同頁面的報表Get reports opened to the same page that was visible when they were saved
  • [欄位] 窗格中資料表內容功能表的 [編輯查詢] 選項 ([報表] & 和 [資料] 檢視)Edit Query option in table context menu in the Fields pane (Report & Data views)
  • 功能區的 [複製頁面]Duplicate Page from the ribbon

資料模型化:Data Modeling:

  • 能夠定義階層Ability to define hierarchies
  • 效能改進:資料表和資料行重新命名的最佳化Performance Improvement: Table & Column rename optimizations

資料連接:Data Connectivity:

  • Oracle 與 Teradata 資料庫的 DirectQuery 支援DirectQuery support for Oracle and Teradata databases
  • DirectQuery – 支援建立導出資料行DirectQuery – support for creating Calculated Columns
  • 支援發行 Analysis Services 即時報表Support for publishing Analysis Services Live reports
  • JSON 檔案連接器JSON File connector
  • SQL Sentry 連接器SQL Sentry connector
  • 不規則 CSV 檔的支援Support for jagged CSV files
  • Exchange 連接器 – OAuth 支援Exchange Connector – OAuth support
  • SharePoint 清單連接器 – URL 驗證SharePoint List Connector – URL validation
  • 資料庫連接器 – 能夠在 [查詢] 預覽中停用瀏覽資料行 (效能最佳化)Database Connectors – ability to disable Navigation Columns in Query previews (Performance optimization)
  • Web 連接器 – 更細緻的認證範圍Web Connector – fine-grained scoping of Credentials
  • [輸入資料] 對話方塊 UX 增強功能Enter Data dialog UX enhancements
  • SAP HANA – 支援使用 Windows 驗證的單一登入 (僅限 Power BI Desktop)SAP HANA – Support for single sign-on with Windows Authentication (Power BI Desktop only)
  • SAP HANA – 支援 [欄位] 標籤SAP HANA – Support for Field labels
  • 在 [選擇資料行] 產生器中將資料行按字母順序排序Alphabetical sort of columns in Choose Columns builder
  • 重新命名/移除/重新排列資料行的效能改進Improved performance of renaming/removing/reordering columns
  • [查詢編輯器] 中的虛擬化預覽Virtualized Preview in Query Editor
  • [查詢編輯器] 中卸載查詢的視覺指標Visual indicator for unloaded queries in Query Editor
  • 按一下即可進行百分比轉換1-click Percentage transform

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

注意

您可能也會想要了解 Power BI 服務的新功能,並請同時查閱 Power BI 行動應用程式的新功能You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

2016 年 1 月更新 (2.31.4280.361)January 2016 Update (2.31.4280.361)

您現在可以下載最新版本的 Power BI DesktopYou can now download the latest version of Power BI Desktop.

在新的一年推出 Power BI Desktop 的改進和增強功能。Ring in the new year with another collection of improvements and enhancements to Power BI Desktop. 下列增強功能是本月 Power BI Desktop 的新功能:The following enhancements are new to Power BI Desktop this month:

報表檢視:Report View:

  • 將框線加入視覺效果Add borders to a visual
  • 將影像背景加入視覺效果Add an image background to a visual

資料連接:Data Connectivity:

  • DirectQuery:現在使用 DirectQuery 模式時也可以建立量值。DirectQuery: you can now create measures when using DirectQuery mode
  • 您現在可以從 [欄位清單] 重新整理個別資料表的資料 (在 [ 報表 ] 檢視和 [ 資料 ] 檢視中),而不只是從功能區 全部重新整理You can now refresh data for individual tables from the Field List (in Report view and Data view), rather than (and in addition to) just being able to refresh all from the ribbon
  • SQL Server Analysis Services 多維度模型探索模式的正式發行 (GA) (不再只是預覽功能)General Availability (GA) for SQL Server Analysis Services Multidimensional models Exploration mode (no longer a preview feature)
  • 階層支援的增強功能Enhancements to hierarchy support
  • SAP HANA 連接器的正式發行 (GA) (不再只是預覽功能)General Availability (GA) for the SAP HANA connector (no longer a preview feature)
  • 在單一 [附加] 作業中附加多個資料表的功能Ability to append multiple tables within a single Append operation
  • 停用資料預覽以在背景下載 (效能最佳化) 的選項Option to disable data previews to download in the background (performance optimization)

其他改進功能:Other Improvements:

  • Internet Explorer 9 (IE9) 瀏覽器支援Support for Internet Explorer 9 (IE9) browser
  • 改進報表呈現、交叉醒目提示等效能。Performance improvements for report rendering, cross-highlighting, and otherwise
  • Power BI Desktop R 整合的增強功能Improvements to R integration in Power BI Desktop

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

2015 年 12 月更新 (2.30.4246.181)December 2015 Update (2.30.4246.181)

12 月是散播歡樂的月份,而 Power BI 小組也依循此傳統,在本月的 Power BI Desktop 更新中帶來更多的更新以及更多的功能。December is a month for giving, and the Power BI team is following suit with more updates, features, and more functionality in this month's Power BI Desktop update. 下列增強功能是本月 Power BI Desktop 的新功能:The following enhancements are new to Power BI Desktop this month:

報表撰寫:Report Authoring:

  • 將窗格與功能區格式化:Formatting Pane and Ribbon:

    • 每個類別目錄服務的資料標籤格式Format data labels per category services
    • 變更視覺效果中顯示的小數位數Change the number of decimal places shown in visuals
    • 變更視覺效果中的文字大小Change text size in visuals
    • 更精確的視覺效果配置:對齊方式、相等間距、大小、位置Ability to layout visuals accurately: alignment, distribute, size, position
    • 透過 [複製格式] 跨多個視覺效果設定樣式Set styles across multiple visuals through Format Painter
    • 首頁 功能區配置最佳化Optimized Home ribbon layout
  • 視覺效果的增強功能:Enhancements to Visualizations:

    • 資料表 視覺效果中排序狀態的視覺提示。Visual cue for sort state in Table visual
    • 新的視覺效果: 堆疊區域New visual: Stacked Area chart
    • 區域 圖與 折線 圖停留時出現的智慧工具提示Smart tooltips for Area and Line charts on hover
    • 可建立 笛卡兒 視覺效果的參考列/地區Ability to create reference line/region for a Cartesian visual
    • 經改善的 圓形 圖與 散佈 圖資料標籤Improved data labels for Pie and Scatter charts
  • Power BI Desktop 中的 R 視覺效果整合 (預覽功能)R Visuals integration in Power BI Desktop (Preview feature)

  • 嘗試建立涉及兩個不相關資料表的視覺效果時,所建議的資料表至資料表關聯性Suggested table-to-table relationships when trying to create visuals involving two tables which are not related

資料模型化:Data Modeling:

  • 關聯性檢視Relationships View
    • 縮放滑桿Zooming slider
    • 縮放至適當螢幕大小Fit Zoom to screen
    • 重設配置Reset layout
    • 用 CTRL+(滑鼠選取範圍) 放大Ability to zoom in CTRL+(mouse selection range)

資料連接:Data Connectivity:

  • SSAS 多維度支援 - 階層支援SSAS Multidimensional support - hierarchies support
  • Stripe ConnectorStripe Connector
  • Smartsheet ConnectorSmartsheet Connector
  • 輸入資料:貼上或輸入資料來建立資料表Enter Data: paste or enter data to create a table
  • DirectQuery 改進功能:支援 T-SQL 與 SAP HANA 所有的資料類型,促進效能改進DirectQuery improvements: support for all data types of T-SQL and SAP HANA, resulting in performance improvements
  • ODBC Connector:支援選取使用者/系統 DSNODBC Connector: support for selecting User/System DSNs
  • CSV Connector:可在 [來源] 對話方塊中指定資料行分隔符號CSV Connector: ability to specify Column Delimiter in the Source dialog

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

2015 年 11 月更新 (2.29.4217.221)November 2015 Update (2.29.4217.221)

您現在可以下載最新版本的 Power BI DesktopYou can now download the latest version of Power BI Desktop.

這個月有更多種 Power BI Desktop 的新功能和增強功能。Another month, another big collection of new features and improvements for Power BI Desktop. 從新的資料連接器到新的模型化功能,有各種功能改善。Improvements range from new data connectors to new modeling capabilities. 以下列出 26 種新功能和增強功能:Here are 26 new features and improvements:

報表撰寫:Report Authoring:

  • 散佈圖的播放軸Play Axis for Scatter Chart
  • 水平交叉分析篩選器Horizontal Slicers
  • 交叉分析篩選器選取項目行為 (單一和多重選取)Slicer Selection Behaviors (single vs. multi-select)
  • 控制項 Z 軸順序Control Z-order
  • 投影片的背景色彩Background Colors for Slides
  • 視覺效果之間的互動 – 子檢視 (依據圖格)Interactions between Visuals – Subview (tile by)
  • 重複的頁面Duplicate Pages
  • 資料表、矩陣和卡片中的 KPI 和影像支援Support for KPIs and Images in Tables, Matrices and Cards
  • 區域圖和折線圖更好的工具提示Better Tooltips on Area Charts & Line Charts
  • 可以變更卡片和資料表/矩陣中的文字大小Ability to change Text size in Cards & Tables/Matrix
  • 欄位區和 [格式] 窗格中改良的工具提示和標籤Improved tooltips and labels in Field Well and Formatting panes
  • 可以檢視不具資料的類別Ability to see Categories with no data
  • 改良視覺效果預設排序行為Improved Default Sort behaviors for visuals
  • 可以控制軸刻度顯示單位Ability to control Axis Scale display units
  • 套用基本模型作業時的視覺效果重新整理最佳化Visuals Refresh Optimizations when applying basic modeling operations

資料模型化:Data Modeling:

  • 基本的自動日期功能Basic Automatic Date Features

資料連接:Data Connectivity:

資料轉換:Data Transformations:

  • 改善函式引動過程經驗Improved Function Invocation experience
  • 可選擇設定在伺服器與資料庫層級的認證Option to set Credentials at Server vs. Database level
  • 將前置詞/後置詞加入文字資料行Add Prefix/Suffix to a Text column

其他改進功能:Other Improvements:

  • 新的文件網站,現在也包括當地語系化內容New Documentation Website, now also including localized content

需要這些更新的詳細資訊嗎?Want more information about these updates? 請參閱部落格文章,您可以從中取得每項新功能的詳細資訊。Take a look at the blog post, where you can get more detailed information about each of these new features.

下列影片將描述並示範這些更新。The following video describes and shows each of these updates. 您也可以從部落格文章觀賞這段影片。You can also see the video from the blog post.

2015 年 10 月更新 (2.28.4190.122)October 2015 Update (2.28.4190.122)

10 月會將另一個大型更新集合帶到 Power BI Desktop:October brings another large collection of updates to Power BI Desktop:

報表撰寫:Report Authoring:

  • 自訂視覺效果Custom Visualizations
  • 從功能區中插入視覺效果Insert Visual from the Ribbon
  • 改良的預設排序Improved Default Sorting
  • 漏斗圖上的工具提示和資料標籤Tooltips & Data Labels on Funnel Charts
  • 交叉分析篩選器的增強功能:Slicer Improvements:
    • 可排序項目Ability to Sort items
    • 可變更字型大小Ability to change Font Size
  • 量測計的其他格式化選項Additional Formatting Options for Gauges
  • 資料點標籤配置增強功能Data Point Label layout improvements
  • KPI 耗用量 (預覽功能)KPI Consumption (Preview Feature)

資料模型化:Data Modeling:

  • 資料檢視中 DAX 公式的準選取支援Semi-Select support for DAX formulas in Data view

資料連接:Data Connectivity:

  • Azure 文件 DB 連接器Azure Document DB connector
  • Mailchimp 連接器Mailchimp connector
  • 適用於 SQL Server 和 Azure SQL Database 的 DirectQuery (預覽功能)DirectQuery for SQL Server and Azure SQL Database (Preview Feature)

資料轉換:Data Transformations:

  • 依「非最早/最新的日期」來篩選Filter by “not earliest/latest date”
  • 依「在前 N 分鐘/小時/秒」篩選Filter by “is in previous N minutes/hours/seconds”
  • 在 Power BI Desktop 和 Excel 之間複製/貼上查詢Copy/Paste Queries between Power BI Desktop and Excel
  • 支援分割資料行中的特殊字元Support for Special Characters in Split Column
  • 在 [合併的查詢] 對話方塊中重新整理預覽Refresh Previews in Merge Queries dialog
  • 查詢編輯器預覽的等寬字型Monospaced font for Query Editor Preview

其他改進功能:Other Improvements:

  • 從報表和資料檢視重新整理單一資料表 (與全部)Refresh Single Table (vs. All) from Report & Data Views
  • 啟用預覽功能的選項Option to enable Preview features
  • 產品內的評等體驗In-Product Ratings experience

您也可以檢視這些更新的視訊。You can view a video of all these updates, too.

如需詳細資訊,請查看部落格通知,內含每個更新的詳細資訊。For more information, check out the blog announcement that describes more details about each update.

2015 年 9 月更新 (2.27.4163.351)September 2015 Update (2.27.4163.351)

此更新已加入下列大規模集合的 44 項功能:The following massive collection of 44 features has been added to this update:

報表撰寫Report Authoring

  • 報表層級篩選Report-level filters
  • 資料行和散佈圖的向上/向下切入Drill Up/Down for column and scatter charts
  • 新的頁面大小和頁面檢視選項New Page Size and Page View options
  • 支援在報表畫布中插入圖形Support for inserting Shapes in the Report canvas
  • [欄位] 窗格的改善Fields pane improvements
    • 搜尋方塊讓您輕易地依名稱尋找欄位Search Box to make it easier to find fields by name
    • 當 [欄位] 窗格中有多個資料表時,「展開/摺疊全部」可改善導覽。“Expand/Collapse All” to improve navigation when there are multiple tables in the Fields pane
    • 欄位具有基數支援、適用於具有 1 個項目之貯體的拖曳取代功能。Field well cardinality support, drag-replace for buckets with 1 item
    • 其他的資料標籤格式化選項Additional Data Labels formatting options
    • 圖表笛卡兒軸改善:Chart Cartesian Axis Improvements:
      • X 軸標籤方向 (水平/對角線)X-Axis label direction (horizontal / diagonal)
      • 支援 Y 軸中之值的對數與線性標尺Support for Logarithmic & Linear scales for values in Y-axis
      • 文字方塊中的超連結顯示文字Display Text for hyperlinks in text boxes
      • 現有視覺效果的改善:資料表、矩陣、交叉分析篩選器、散佈圖、單一卡片、組合式圖表及量測計Improvements to existing visualizations: Table, Matrix, Slicer, Scatter Chart, Single Cards, Combo Charts and Gauges
      • 支援在工具提示中顯示色彩飽和度的值Support for displaying Color Saturation values in tooltips
      • 可以調整影像的大小並套用其他格式化選項Ability to resize images and apply additional formatting options

資料模型化Data Modeling

  • 導出的資料表。Calculated Tables.
  • 關聯性檢視:Relationships view:
    • 透過在圖表中的兩個資料表間進行拖放來建立關聯性。Create relationships via drag/drop between two tables in the diagram.
    • 透過選取並按下 Delete 鍵來刪除關聯性檢視中的關聯性。Delete relationships in relationship view by selecting and hitting the Delete key.
    • 重新命名/刪除資料表和資料行Rename/delete tables and columns
  • 資料檢視:Data view:
    • 將表格內容複製到剪貼簿。Copy Table contents to clipboard.
  • 欄位摘要:Field Summarization:
    • 支援 [欄位] 窗格中的其他作業:中位數、標準差及差異Support for additional operations in the Fields pane: median, standard deviation, and variance
    • 預設摘要:使用者現在可以自訂其模型中任何給定欄位的預設摘要作業Default summarization: Users can now customize the default summarization operation for any given field in their model

資料連接Data Connectivity

  • 支援內部部署 Spark 散發Support for on-premises Spark distributions
  • 支援非英文網站的 SharePoint 清單Support for SharePoint lists from non-English sites
  • Exchange 連接器 - 增強的支援,現在允許連接到多個信箱Exchange connector - Enhanced support, now allowing connections to multiple mailboxes
  • Excel 活頁簿連接器 – 匯入 .XLS 檔案時自動偵測資料行類型Excel Workbook Connector – Automatic Column Type detection when importing .XLS files
  • 連接到資料庫來源時的「選取相關的資料表」選項“Select Related Tables” option when connecting to database sources
  • 增強的 Active Directory 連接器認證,允許替代的 Windows 認證Enhanced Active Directory connector credentials, allowing alternate Windows Credentials
  • 從資料來源 (例如資料庫) 載入函式時,經改善的函式引動過程經驗Improved Function Invocation experience when loading functions from a data source (such as a database)
  • 上個月發行的「匯入 Excel 活頁簿內容」功能現在也支援 Analysis Services 表格式模型的外部連接“Import Excel Workbook Contents” feature released last month now also supports external connections to Analysis Services tabular models
  • [資料來源設定] 對話方塊中 [全部刪除] 項目的新選項New option to “Delete All” entries in the Data Source Settings dialog
  • [重新整理作業期間啟用關聯性匯入] 的選項Option to “Enable Relationship Import during Refresh operations”

資料轉換和查詢編輯器的改善Data Transformations and Query Editor Improvements

  • 複製到剪貼簿 (適用於資料格/資料行/資料表)Copy to clipboard (available for cells/columns/tables)
  • 依最早/最新日期 (動態篩選) 篩選日期資料行Filter date columns by earliest/latest date (dynamic filter)
  • 從資料行中擷取最小/最大日期/時間值Extract min/max date/time value from a column
  • 取代值 - 針對指定特殊字元的佈建Replace Values - Provision for specifying special characters
  • [偵測資料行類型] 選項可用以觸發隨選的類型偵測“Detect Column Types” option to trigger type detection on demand
  • 只要按一下 [重新整理所有預覽] 便可重新整理所有的查詢編輯器預覽“Refresh All Previews” to refresh all Query Editor previews with a single click
  • 效能改進效能改進Performance Improvements:
    • 選擇 [資料行] 對話方塊:針對處理寬型資料表,可獲得更快速的使用者經驗Choose Columns dialog: Faster user experience for dealing with wide tables
    • 自動篩選與展開/彙總快顯:針對大量的值/欄位,可提供更快速的處理Auto-filter & Expand/Aggregate popups: Faster for large number of values/fields

下列影片涵蓋更多這些功能的詳細資料。The following video covers these features in more detail.

如需這項更新的詳細資訊,請查看部落格通知,內含每個更新的詳細資訊。For more information about this update, check out the blog announcement that describes more details about each update.

2015 年 8 月更新 (2.26.4128.403)August 2015 Update (2.26.4128.403)

此更新已加入下列功能:The following features have been added to this update:

整體改進:Overall Improvements:

  • 將 Excel 的 Power BI 成品 (資料模型、查詢、Power View) 匯入到新的 Power BI Desktop 檔案Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file

  • HDInsight Spark 連接器HDInsight Spark connector

  • Azure SQL 資料倉儲連接器Azure SQL Data Warehouse connector

  • 從 SSAS 匯入資料時支援自訂 MDX/DAQ 查詢Support for custom MDX/DAQ queries when importing data from SSAS

  • 即時的 Analysis Services 連接:能夠從 [編輯查詢] 對話方塊變更資料庫Live Analysis Services Connections: ability to change the database from Edit Queries dialog

導覽器對話方塊改進Navigator dialog improvements:

  • 可調整大小的導覽器對話方塊Resizable Navigator dialog

  • 在導覽器多重選取項目的能力 (CTRL + 按一下、SHIFT + 按一下,等等)Ability to multi-select items in Navigator (CTRL+click, SHIFT+click, etc)

查詢編輯器改進:Query Editor improvements:

  • 查詢群組建立/刪除改進 (多重選取等等)Query Group creation/deletion improvements (multi-select, etc.)

  • 分割查詢 (也就是將通用基底步驟重整成新的查詢) 的能力Ability to Split Query (i.e. refactor common base steps into a new query)

  • 查詢圖示可在查詢導覽器窗格中反映查詢類型Query Icons to reflect type of query in Queries navigator pane

資料模型化改進:Data Modeling improvements:

  • 在資料檢視中調整資料行的大小Resizing of columns in Data View

  • 將量值從一個資料表移動到另一個資料表Moving Measures from one table to another

看看下列影片以取得關於此更新的詳細資訊:Take a look at the following video for more details about this update:

2015 年 7 月更新 (2.25.4095.554)July 2015 Update (2.25.4095.554)

此更新已加入下列功能:The following features have been added in this update:

  • 新的資料連接器:appFigures Quickbooks Online、Zendesk、Github、Twilio 和 SweetIQ。New Data Connectors: appFigures, Quickbooks Online, Zendesk, Github, Twilio and SweetIQ.

  • 新的轉換:從文字資料行擷取第一個/最後一個/字元範圍;在 [合併的查詢] 對話方塊中指定聯結類型的選項;在 [依分隔符號分割資料行] 對話方塊中自訂引號樣式的能力。New Transformations: Extract First/Last/Range of characters from a Text Column; Option to specify Join Type in the Merge Queries dialog; Ability to customize Quote Style in Split Column by Delimiter dialog.

  • 報表撰寫改進:新的視覺效果 (區域圖、瀑布、甜甜圈和矩陣);新的視覺格式設定和自訂選項 (標籤、標題、背景、圖例、色彩等等);在報表中插入文字方塊和圖片;在報表和報表資料表中支援超連結;復原/取消復原動作。Report Authoring Improvements: New visualizations (Area Chart, Waterfall, Donut & Matrix); New visual formatting and customization options (labels, titles, background, legend, colors, etc.); Insert Textbox and Picture in your report; Support for hyperlinks in reports and report tables; Undo/Redo actions.

  • 對 Analysis Services 表格式模型的直接報表瀏覽Direct Report Exploration over Analysis Services Tabular Models.

  • 資料模型化:新的資料檢視與關聯性檢視。Data Modeling: New Data View & Relationships views.

  • 直接從 Power BI Desktop 將報表發行至 PowerBI.com。Publish reports to PowerBI.com, directly from Power BI Desktop.

  • 支援在起始頁和 [檔案 -> 開啟] 功能表中開啟最近使用的檔案。Support for opening Recent Files in Start Page and "File -> Open" menu.

  • 支援 Exchange 連接器中的 Exchange UPN 認證。Support for Exchange UPN Credentials in the Exchange connector.

除了所有這些新功能,我們也正在提供 42 種不同語言版本的 Power BI DesktopIn addition to all these new features, we’re also making Power BI Desktop available in 42 different languages. 我們的官方下載頁面取得語言的完整清單,並安裝您要的語言。Get the full list of languages and install the one you want from our official download page.

看看下列影片以取得詳細資訊:Take a look at the following video for more details:

2015 年 5 月更新 (2.23.4036.161)May 2015 Update (2.23.4036.161)

此更新已加入下列功能:The following features have been added in this update:

模型化功能Modeling Features

  • 導出資料行Calculated Columns

  • 資料分類Data Categorization

  • 依其他資料行排序Sort By Another Column

  • 改良的 DAX 公式編輯器:函數說明和原型Improved DAX Formula Editor: Function Help and Prototype

取得資料與查詢Get Data & Query

  • 新的 ODBC 資料表 連接器 (Beta)New ODBC Tables connector (Beta)

  • 改善 Excel 活頁簿 連接器:更好的資料行類型推斷並更快速載入資料預覽Improved to the Excel Workbook connector: better column type inference and faster load for data previews

  • 新的文字資料行篩選 - 「開頭不是」 和「結尾不是」 New Text Column Filters - Does Not Begin With and Does Not End With

  • 增強的私密性等級對話方塊Enhanced Privacy Levels dialog

看看下列影片以取得詳細資訊:Take a look at the following video for details:

2015 年 4 月更新 (2.22.4009.122)April 2015 Update (2.22.4009.122)

您現在可以下載最新版本的 Power BI DesktopYou can now download the latest version of Power BI Desktop.

此更新已加入下列功能:The following features have been added in this update:

模型化功能Modeling Features

  • DAX 量值的初始支援Initial support for DAX Measures

  • 新的 DAX 函數New DAX functions

  • 報表檢視中的資料類型與格式化選項Data Types & Formatting options in Report view

  • 在報表檢視中重新命名和刪除欄位Rename & Delete fields in Report view

取得資料與查詢Get Data & Query

  • OData V4 支援OData V4 support

  • 自訂 ADFS 驗證服務的支援Support for Custom ADFS Authentication Services

  • 因為 Facebook API 變更而更新的 Facebook 連接器Updated Facebook connector due to Facebook API changes

  • [統一的選項] 對話方塊Unified Options dialog

  • 停用原生資料庫查詢提示的選項Option to disable Native Database query prompts

  • 支援「固定十進位數字」 類型Support for Fixed Decimal Number type

  • 替代的 Windows 認證Alternate Windows Credentials

  • 移除空白資料列Remove Blank Rows

  • 用於群組依據彙總資料行的中間值作業Median Operation available for Group By and Aggregate Column

  • DateTimeZone 值轉換為「本地時間」 Convert DateTimeZone value to Local Time

效能提升Performance Improvements

  • 載入中型和大型資料集的速度加快大約 20%Faster load of medium & large datasets by about 20%

  • 開啟現有 PBIX 檔案的時間改善大約 50%Improved time to open an existing PBIX file by about 50%

看看下列影片以取得詳細資訊:You can watch the following video for details:

2015 年 3 月更新 (2.21.3975.261)March 2015 Update (2.21.3975.261)

此更新已加入下列功能:The following features have been added in this update:

  • Google Analytics 連接器Google Analytics connector

  • 用於在查詢檢視中進行日期篩選的其他運算子Additional operators for date filtering in Query view

  • 模型關聯性自動偵測Automatic Model Relationship Detection

  • 增強的 [加入關聯性] 對話方塊Enhanced Add Relationship dialog

  • 報表頁面重新排序 (拖放)Report Pages Re-ordering (drag & drop)

  • ~ 40-50% 效能 改進 ,填滿沒有篩選/轉換的資料庫資料表~40-50% Performance Improvement filling database tables without filters/transforms

  • 很多 Bug 修正Lots of bug fixes

看看下列影片以取得詳細資訊:You can watch the following video for more details:

2015 年 2 月更新 (2.20.3945.102)February 2015 Update (2.20.3945.102)

此更新已加入或改進下列功能:The following features have been added or improved in this update:

  • 效能改進Performance improvements
  • Dynamics CRM Online 連接器Dynamics CRM Online connector > [!NOTE] > 目前此對話方塊只接受 crm.microsoft.com 網域內的 URL。Currently, only URLs within the crm.microsoft.com domain are accepted by this dialog. 這不包括非生產租用戶。This does not include non-production tenants. 我們將在我們的 3 月更新中修正此問題。We’ll fix this issue in our March update. 暫時的解決方法是使用 “From OData” 連接到這個摘要。The temporary workaround is to connect to this feed using “From OData”.
  • 導覽器對話方塊改進Navigator Dialog improvements
    • 更好的多維度來源 (Analysis Services 和 SAP BusinessObjects) 預覽經驗Better preview experience for multi-dimensional sources (Analysis Services and SAP BusinessObjects)
    • 顯示選取項目選項Show Selected Items option
    • 改進導覽器樹狀目錄中的搜尋功能Improved Search capabilities in the Navigator tree
  • 新的轉換New Transformations
    • 日期/時間資料行的年齡和減法運算Age and Subtract operations for Date/Time columns
    • 彙總資料行:停用新資料行前置詞的選項Aggregate Columns: Option to disable new columns’ prefix
  • 欄位清單改進Field List improvements
    • 展開/摺疊資料表Expand/Collapse tables
    • 隱藏/取消隱藏欄位Hide/Unhide fields
    • 最佳化的配置 (間距、邊界和字型)Optimized layout (spacing, margins, and fonts)
  • 報表頁面導覽 - 鍵盤支援Report Pages Navigation - Keyboarding support
  • 很多 Bug 修正Lots of bug fixes

2015 年 1 月更新 (2.19.3923.101)January 2015 Update (2.19.3923.101)

本月份我們做了許多幕後的改進和 Bug 修正。This month we've made a number of improvements and bug fixes under the covers. 請試試新的版本,並繼續在發現任何問題時傳送意見反應給我們!Please try out the new version and continue to send us feedback if you find any issues!