在 Power BI 中可视化来自 Azure 时序见解的数据Visualize data from Azure Time Series Insights in Power BI

Azure 时序见解是可在云中存储、管理、查询和可视化时序数据的平台。Azure Time Series Insights is a platform for storing, managing, querying, and visualizing time-series data in the cloud. Power BI 是一个业务分析工具,它提供丰富的可视化功能让你在组织中共享见解和结果。Power BI is a business analytics tool with rich visualization capabilities that allows you to share insights and results across your organization. 这两个服务现在可以集成到一起,以充分利用 Azure 时序见解和 Power BI 固有的可视化功能。Both services can now be integrated to get the best of both Azure Time Series Insights' inherent visualization capabilities as well as Power BI's.

将了解如何执行以下操作:You'll learn how to:

  • 使用云连接器将 Azure 时序见解连接到 Power BIConnect Azure Time Series Insights to Power BI using the cloud connector
  • 使用 Power BI 中的数据创建视觉对象Create visuals with your data in Power BI
  • 将报表发布到 Power BI,然后与组织中的其他人共享Publish the report to Power BI and share with the rest of your organization

最后,了解如何通过 Azure 时序见解可视化时序数据,然后使用 Power BI 的强大数据可视化功能和轻松共享功能增强这些数据。By the end, you'll learn how to visualize time-series data through Azure Time Series Insights and enhance it with the strong data visualization and easy sharing capabilities of Power BI.

如果没有 Azure 订阅,请务必注册一个 Azure 订阅Make sure to sign up for a Azure subscription if you don't already have one.

先决条件Prerequisites

重要

  • 当前,仅配置有“Warm 存储”的 Azure 时序见解 Gen2 环境支持该连接器。The connector is presently supported in Azure Time Series Insights Gen2 environments configured with Warm Store only.
  • 如果你有从另一个 Azure AD 租户访问 Azure 时序见解 Gen2 环境的来宾访问权限,则将无法访问该连接器。If you have guest access to the Azure Time Series Insights Gen2 environment from another Azure AD Tenant, you will not be able to access the connector. 请参阅环境访问策略Read about the environment access policies.

将数据从 Azure 时序见解连接到 Power BIConnect data from Azure Time Series Insights to Power BI

若要将 Azure 时序见解环境连接到 Power BI,请执行以下步骤:To connect your Azure Time Series Insights environment to Power BI, follow these steps:

  1. 打开 Azure 时序见解资源管理器Open Azure Time Series Insights Explorer
  2. 将数据导出为查询或原始数据Export data as a query or as raw data
  3. 打开 Power BI DesktopOpen Power BI Desktop
  4. 从自定义查询加载Load from Custom Query

将数据导出到 Power BI DesktopExport data into Power BI desktop

开始操作:To get started:

  1. 打开 Azure 时序见解资源管理器并策展数据。Open the Azure Time Series Insights Explorer and curate your data.

  2. 创建满意的视图后,导航到“更多操作”下拉菜单,然后选择“连接到 Power BI” 。Once you have created a view you are satisfied with, navigate to the More actions dropdown menu and select Connect to Power BI.

    Azure 时序见解资源管理器导出Azure Time Series Insights Explorer export

  3. 在此选项卡中设置参数:Set your parameters inside this tab:

    1. 指定视图的相对时间范围。Specify a relative timeframe to view. 如果对现有视图感到满意,请保留“现有时间范围”。If you are happy with your existing view, leave this as Existing timeframe.

    2. 选择“聚合”或“原始事件”。Choose between Aggregated and Raw Events.

      备注

      以后始终可以在 Power BI 中聚合数据,但聚合后无法还原为原始数据。You can always aggregate your data later in Power BI, but you cannot revert to raw data after aggregation.

      备注

      原始事件级别数据的事件计数限制为 250,000 个。There is a 250,000 event count limit for Raw Event level data.

      连接Connect

    3. 如果尚未使用“Warm 存储”配置 Azure 时序见解环境,会收到一条警告。If you have not configured your Azure Time Series Insights environment with Warm Store, you will receive a warning.

      Warm 存储警告Warm store warning

      提示

      可以在 Azure 门户中为“Warm 存储”配置现有的实例。You may configure your existing instance for Warm Store in the Azure portal.

  4. 选择“将查询复制到剪贴板”。Select Copy query to clipboard.

  5. 现在启动 Power BI Desktop。Now, launch Power BI Desktop.

  6. 在 Power BI Desktop 中的“主页”选项卡上,选择左上角的“获取数据”,然后选择“更多”。In Power BI Desktop on the Home tab, select Get Data in the upper left corner, then More.

    “主页”下拉菜单Home dropdown

  7. 搜索“Azure 时序见解”,依次选择“Azure 时序见解(Beta)”、“连接”。 Search for Azure Time Series Insights, select Azure Time Series Insights (Beta), then Connect.

    将 Power BI 连接到 Azure 时序见解Connect Power BI to Azure Time Series Insights

    或者,导航到“Azure”选项卡,并依次选择“Azure 时序见解(Beta)”、“连接”。Alternatively, navigate to the Azure tab, select Azure Time Series Insights (Beta), then Connect.

  8. 此时会显示一个消息对话框,要求授予连接到第三方资源的权限。A message dialogue box will display asking for permission to connect to third-party resources. 请选择“继续”。Select continue.

    选择“创建自定义查询”Choose Create Custom Query

  9. 在“数据源”下面的下拉菜单中,选择“创建自定义查询”。In the dropdown menu under Data Source, choose Create custom query. 将剪贴板中的内容粘贴到下面的“自定义查询(可选)”可选字段中,然后按“确定”。Paste from your clipboard into the optional Custom Query (optional) field below, then press OK.

    传入自定义查询并选择“确定”Pass in the custom query and select OK

  10. 随即会加载数据表。The data table will now load. 按“加载”以载入 Power BI。Press Load to load into Power BI.

    检查表中的加载数据并选择“加载”Review the loaded data in the table and select Load

如果已完成这些步骤,请跳到下一部分。If you have completed these steps, skip ahead to the next section.

使用视觉对象创建报表Create a report with visuals

将数据导入 Power BI 后,接下来请生成包含视觉对象的报表。Now that you have imported the data into Power BI, it’s time to build a report with visuals.

  1. 在窗口的左侧,确保已选择“报表”视图。On the left side of the window, make sure you have selected the Report view.

    屏幕截图显示“报表”视图图标。Screenshot shows Report view icon.

  2. 在“可视化效果”列中,选择所需的视觉对象。In the Visualizations column, select your visual of choice. 例如,选择“折线图”。For example, select Line chart. 这会在画布中添加一个空白的折线图。This will add a blank line chart to your canvas.

  3. 在“字段”列表中选择“_时间戳”,然后将此时间戳拖放到“轴”字段以显示 X 轴上的项。 In the Fields list, select _Timestamp and drag it to the Axis field to display items along the X-axis. 确保切换到“_时间戳”,作为“轴”的值(默认为“数据层次结构”) 。Make sure to switch to _Timestamp to as the value for the Axis (default is Date Hierarchy).

    屏幕截图显示已选择“时间戳(_T)”的时间戳菜单。Screenshot shows Timestamp menu with _Timestamp selected.

  4. 同样,请在“字段”列表中选择“时序 ID”,然后将此 ID 拖放到“值”字段以显示 Y 轴上的项。Again, in the Fields list, select TimeSeriesId and drag it to the Values field to display items along the Y-axis.

    创建折线图Create a line chart

  5. 若要将另一个图表添加到画布,请选择画布上折线图外部的任意位置,并重复上述过程。To add another chart to your canvas, select anywhere on the canvas outside the line chart and repeat this process.

    创建要共享的其他图表Create additional charts to share

创建报表后,可将其发布到 Power BI Reporting Services。Once you have created your report, you can publish it to Power BI Reporting Services.

高级编辑Advanced editing

如果已在 Power BI 中加载了一个数据集,但想要修改查询(例如日期/时间或环境 ID 参数),可以通过 Power BI 的高级编辑器功能实现此目的。If you have already loaded a dataset in Power BI but would like to modify the query (such as the date/time or Environment ID parameters), you can do this via Power BI’s Advanced Editor functionality. 有关详细信息,请参阅 Power BI 文档Refer to the Power BI documentation to learn more.

功能概述:As an overview:

  1. 在 Power BI Desktop 中选择“编辑查询”。In Power BI Desktop, select Edit Queries.

  2. 按“高级编辑器”。Press Advanced Editor.

    在高级编辑器中编辑查询Edit queries in the Advanced Editor

  3. 根据需要修改 JSON 有效负载。Modify the JSON payload as desired.

  4. Power Query 编辑器窗口 中,依次选择“完成”、“关闭并应用”。Select Done and then Close & Apply within the Power Query Editor Window.

现在接口会反映你应用的所需更改。The interface will now reflect the desired changes you applied.

后续步骤Next Steps