Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

1-4B

0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
As you build up more and more queries within your Power BI desktop files, you might find that the query list on the left-hand side can grow and grown. And as you've seen in maybe some of the other videos, we can create these folders to help group them up and manage them a little bit more easily. But you can also view the dependencies between these queries. So it may be that if you've got lots and lots of different queries coming in, you want to understand, okay well which ones reference each other? Where do they all come from? What beta sources and connections are we using? And try to understand if I change columns in one, is it going to have an impact on any of the other queries? We got into this query dependence view to help with that. So here you can see the data sources, the individual connections that are being used, and all the queries that might use those and how they're related to one another. We've got a few different things that we can do here. One is that by selecting any of the objects within this view, you'll see its highlighted. And it highlights all of the things that are either dependent on the thing that you selected or have references to that thing you selected. If I choose this data source, I can see that my orders and order details table come from there. And I can see this orders by customer table is related and dependent on that data source originally. I can see these arrows that show how they flow through. Now I can pan around and zoom in and out of these views if it's getting particular big, and I can relay them out in different ways that might help me better understand the different tables within here. I could also—if I'm zoomed in too far, I've got this button here to always fit it back so that I can see it within the screen. There's a few other things that you'll notice on here. For example, these icons show me the state of these queries whether or not they've been loaded, whether there's any problems with them. So it can help me identify issues with the whole set of queries that are in this Power BI desktop file. So for example, when I select one of these that's got an issue, I can see, okay well actually maybe the problem wasn't necessarily in this table. It was actually in one that it was referring to earlier on. So it's a really useful way—this query dependency view— just to get an idea of how data's flowing through all of the different transformations and all of the different queries that you're building up within your Power BI file.

Video Details

Duration: 2 minutes and 24 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 5
Posted by: csintl on Dec 10, 2016

----- (Please provide translations for these languages: Chinese (Simplified) (chi_hans), Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus), Spanish (spa).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.