Getting comprehensive power over your papers at any moment is crucial to ease your day-to-day tasks and enhance your productivity. Accomplish any objective with DocHub tools for document management and convenient PDF file editing. Gain access, adjust and save and incorporate your workflows with other protected cloud storage.
DocHub offers you lossless editing, the possibility to use any formatting, and securely eSign papers without the need of looking for a third-party eSignature option. Obtain the most of the document managing solutions in one place. Try 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