Excel Magic Trick 1384

Import Excel Table or Sheet in Power Query or Power BI?


Compare and Contract importing a Proper Data Set from either an Excel Sheet or an Excel Table using the Excel Table feature. See that the Excel Table is more robust because it will exclude data on a sheet that is outside the Excel Table.


Download “Excel Magic Trick 1381-1385” Excel-Magic-Trick-1381-1385.zip – Downloaded 122 times – 81 MB

Be the first to comment

Leave a Reply