Getting full control over your documents at any time is crucial to alleviate your everyday duties and boost your productivity. Achieve any goal with DocHub features for papers management and practical PDF editing. Gain access, change and save and integrate your workflows with other safe cloud storage services.
DocHub offers you lossless editing, the possibility to use any formatting, and securely eSign documents without having looking for a third-party eSignature alternative. Obtain the most of the document management solutions in one place. Check out all DocHub features today with your 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