-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Power Query Cookbook
By :

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.
In this recipe, you will need to connect to Azure SQL Database with AdventureWorks
data. You need to have access to a running database.
Once you open Power BI Desktop, perform the following steps:
Figure 5.34 – Azure SQL database
Figure 5.35 – SQL Server information
Figure 5.36 – Azure SQL database...