From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,300 courses taught by industry experts.

Organize and document Power Query

Organize and document Power Query - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Organize and document Power Query

“

- [Instructor] Okay, so let's now talk about a topic that nobody likes to talk about, and that is documentation. So let's go ahead inside of Power Query here, and let's do a little bit of organization and documentation. It's not what people generally like to do, but it's really important inside of Power Query, and pretty much any technology, for that matter, to go ahead and document what has been done so that you in the future can pick it up and support it, or if you hand this over to somebody else, they can do the same. So let's go ahead and organize our queries first. So you can see, we really haven't done a lot with Power Query yet. This is actually a really small model. And already we have, quite a few queries have been written. So what I'm going to do is organize these into groups. So I'm just going to go ahead and right-click in an empty spot here in the Queries pane and say New Group. And now I'm going to go ahead and set up a group called Facts. So if you recall, earlier, we…

Contents