具有 DirectQuery 的 Azure SQL 数据仓库Azure SQL Data Warehouse with DirectQuery

通过具有 DirectQuery 的 Azure SQL 数据仓库可以基于在 Azure SQL 数据仓库中已具有的数据和指标来创建动态报表。Azure SQL Data Warehouse with DirectQuery allows you to create dynamic reports based on data and metrics you already have in Azure SQL Data Warehouse. 借助 DirectQuery,查询会在你浏览数据时实时发送回 Azure SQL 数据仓库。With DirectQuery, queries are sent back to your Azure SQL Data Warehouse in real time as you explore the data. 这种情况与 SQL 数据仓库的规模相结合,使用户可以在数分钟内针对以 TB 计的数据创建动态报表。This, combined with the scale of SQL Data Warehouse enables users to create dynamic reports in minutes against terabytes of data. 此外,在 Power BI 中打开按钮的引入使用户可以直接将 Power BI 连接到其 SQL 数据仓库,而不必手动指定信息。In addition, the introduction of the Open in Power BI button allows users to directly connect Power BI to their SQL Data Warehouse without having to manually specify the information.

何时使用 SQL 数据仓库连接器:When using the SQL Data Warehouse connector:

  • 在连接时指定完全限定的服务器名称(请参阅下文以了解详细信息)Specify the fully qualified server name when connecting (see below for details)
  • 确保服务器的防火墙规则配置为“允许访问 Azure 服务”Ensure firewall rules for the server are configured to "Allow access to Azure services"
  • 每个操作(例如选择列或添加筛选器)都会直接查询数据仓库Every action such as selecting a column or adding a filter will directly query the data warehouse
  • 磁贴设置为大约每 15 分钟刷新一次,刷新不需要进行计划。Tiles are set to refresh approximately every 15 minutes and refresh does not need to be scheduled. 连接时可以在“高级设置”中对此进行调整。This can be adjusted in the Advanced settings when you connect.
  • 问答不可用于 DirectQuery 数据集Q&A is not available for DirectQuery datasets
  • 不会自动选取架构更改schema changes are not picked up automatically

随着我们继续改进体验,这些限制和说明可能会发生变化。These restrictions and notes may change as we continue to improve the experiences. 下面详细介绍了用于连接的步骤。The step to connect are detailed below.

使用“在 Power BI 中打开”按钮Using the 'Open in Power BI' button

在 SQL 数据仓库与 Power BI 之间移动的最简单方法是使用 Azure 预览门户中的在 Power BI 中打开按钮。The easiest way to move between your SQL Data Warehouse and Power BI is with the Open in Power BI button within the Azure Preview Portal. 通过此按钮可以无缝地开始在 Power BI 中创建新仪表板。This button allows you to seamlessly begin creating new dashboards in Power BI.

  1. 若要开始,请在 Azure 预览版门户中导航到 SQL 数据仓库实例。To get started, navigate to your SQL Data Warehouse instance in the Azure Preview Portal. 请注意,SQL 数据仓库当前只在 Azure 预览门户中存在。Please note that SQL Data Warehouse only have a presence in the Azure Preview portal at this time.
  2. 单击在 Power BI 中打开按钮Click the Open in Power BI button

  3. 如果我们无法直接使你登录,或者如果你没有 Power BI 帐户,则你需要登录。If we are not able to sign you in directly or if you do not have a Power BI account, you will need to sign in.
  4. 你会定向到 SQL 数据仓库连接页面(其中预填充了 SQL 数据仓库中的信息)。You will be directed to the SQL Data Warehouse connection page, with the information from your SQL Data Warehouse pre-populated. 输入凭据并点击连接以创建连接。Enter your credentials and hit connect to create a connection.

通过 Power BI 连接Connecting through Power BI

SQL 数据仓库还在 Power BI 获取数据页面上列出。SQL Data Warehouse is also listed on the Power BI Get Data page.

  1. 在左侧导航窗格底部选择“获取数据”。Select Get Data at the bottom of the left navigation pane.

  2. 数据库中,选择获取Within Databases, select Get.

  3. 选择SQL 数据仓库 > 连接Select SQL Data Warehouse > Connect.

  4. 输入所需信息进行连接。Enter the necessary information to connect. 下面的查找参数部分显示此数据 Azure 门户中可能所处的位置。The Finding Parameters section below shows where this data can be located in your Azure Portal.

    备注

    用户名将是在你的 Azure SQL 数据仓库实例中定义的用户。The username will be a user that is defined in your Azure SQL Data Warehouse instance.

  5. 通过选择新磁贴或新创建的数据集(由星号指示)来钻取到数据集中。Drill into the dataset by selecting the new tile or the newly created dataset, indicated by the asterisk. 此数据集会具有与数据库相同的名称。This dataset will have the same name as your database.

  6. 你可以浏览所有表和列。You can explore all of the tables and columns. 选择某列会将查询发送回源,从而动态创建视觉对象。Selecting a column will send a query back to the source, dynamically creating your visual. 筛选器也会转换为返回到数据仓库的查询。Filters will also be translated into queries back to your data warehouse. 这些视觉对象可以保存在新报表中,并重新固定到仪表板。These visuals can be saved in a new report and pinned back to your dashboard.

查找参数值Finding Parameter Values

可以在 Azure 预览门户中找到你的完全限定的服务器名称和数据库名称。Your fully qualified server name and database name can be found in the Azure Preview Portal. 请注意,SQL 数据仓库当前只在 Azure 预览门户中存在。Please note that SQL Data Warehouse only have a presence in the Azure Preview portal at this time.

后续步骤Next steps

Power BI 入门Get started with Power BI
获取 Power BI 的数据Get Data for Power BI
Azure SQL 数据仓库Azure SQL Data Warehouse
更多问题?More questions? 尝试参与 Power BI 社区Try the Power BI Community