Having complete control over your papers at any time is essential to alleviate your everyday duties and improve your productivity. Achieve any goal with DocHub features for papers management and hassle-free PDF editing. Access, modify and save and integrate your workflows with other protected cloud storage.
DocHub gives you lossless editing, the possibility to use any format, and safely eSign documents without having looking for a third-party eSignature alternative. Maximum benefit of your file managing solutions in one place. Check out all DocHub capabilities today 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