Having full power over your files at any moment is important to alleviate your everyday tasks and increase your efficiency. Accomplish any objective with DocHub tools for document management and hassle-free PDF editing. Gain access, adjust and save and incorporate your workflows with other secure cloud storage.
DocHub offers you lossless editing, the chance to work with any formatting, and safely eSign documents without looking for a third-party eSignature software. Obtain the most of your file management solutions in one place. Check out all DocHub features right now with the free account.
in this video phils going to show you how to extract data from records and lists in power query and this is a question we see regularly which is not surprising because records and lists are fundamental to power query however you might be surprised how easy it is to extract that data with a custom column now phil will be using excel to demonstrate but it works the same in power bi in some scenarios you may even have a situation where you have records inside lists or lists inside records in this first scenario if we look at the second column here of data you can see in this list i have a record the second list is actually empty the third and the fifth rows are blank and the fourth row contains a list that has a record inside it ive seen this type of data structure from things like apis and sometimes when youre pulling different types of data from sharepoint but whatever the source of your data you need to know how to extract particular bits of information from inside your lists or re