If you are regularly using Power Query to create the same transformations on the same dataset, it may be preferable to create a template file so that you don’t have to always start from scratch. In the Power Query window, go to Advanced Editor from the Home tab. Copy the full code from the ‘let’ Read More …

If you have a Power Pivot data model but want to make some of the information accessible in a row by row listing, this can be done by following these steps: From the Data menu, within ‘Get External Data’, select ‘Existing Connections’ and go to the Tables tab. Select your import data option, it can be Read More …