Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 209 of 212

197 C H A P T E R 9 | Introducing Azure SQL Data Warehouse Warehouse tile is displayed in your default dashboard in the Power BI window. Click this tile to access the Power BI report designer. A more common way for users to access SQL Data Warehouse from Power BI is to click the Get Data button in Power BI, click Databases, and then click the Azure SQL Data Warehouse tile, shown in Figure 9-11. Next, click the Connect button to open the prompt for the server, database, and advanced options described earlier. If you are using Power BI Desktop, click Get Data, select Microsoft Azure SQL Data Warehouse in the list of sources, click Connect, supply connection and credentials information, and select the tables or views to use in Power BI. Figure 9-11: Getting data for Power BI. Regardless of which path you take to connect to your data warehouse, you can then build reports and dashboards by using visualizations based on data from your data warehouse, as shown in Figure 9-12. You can expand tables in the Fields panel to find the column names that you want to use in a visualization. You can choose a different type of visualization in the Visualizations panel to view your data from a different perspective. You can also resize the visualization or move it to a different location on the page. A report page can even contain multiple visualizations. Click an empty spot on the page and select fields from the Fields panel to create a new visualization. Figure 9-12: Visualizing SQL Data Warehouse data in Power BI. Note To successfully use Power BI, you must be sure that the client IP addresses for users are configured in the firewall settings for the server and enable the Allow Access To Azure Services

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016