Using the Query Dependencies view
Once you become confident using Power Query, you can start adding a higher number of queries, combining them, and applying complex transformation logic. You can often get lost in terms of how queries were built and merged and you may need a view that allows you to map data sources and queries. In this recipe, we will see how the Query Dependencies view will allow us to quickly see what is going on in that Power Query session.
Getting ready
In this recipe, you will need to connect to Azure SQL Database with AdventureWorks data. You need to have access to a running database.
How to do it…
Once you open Power BI Desktop, perform the following steps:
- Go to Get data, click on More…, and browse for Azure SQL database:
Figure 5.34 – Azure SQL database
- Enter the server name of your Azure SQL database:
Figure 5.35 – SQL Server information
- Enter authentication details:
Figure 5.36 – Azure SQL database...
