I show how you can take a table that lists “Record” and expand that within Power BI. This also works with Power Query. I have a look at the M Syntax and show a cleaner approach.