Having full control of your files at any moment is crucial to ease your daily tasks and improve your productivity. Accomplish any goal with DocHub tools for papers management and practical PDF editing. Gain access, change and save and incorporate your workflows along with other protected cloud storage services.
DocHub provides you with lossless editing, the chance to work with any formatting, and securely eSign documents without the need of looking for a third-party eSignature alternative. Make the most of the document management solutions in one place. Consider all DocHub functions 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
