Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel

You may also like...

2 Responses

  1. Leo Cohn says:

    One option that I have used successfully is to link each tab in the workbook to a table in the database, using Excel’s built-in embedded connectivity. It is less code and does not depend on having any module, etc., installed.

    • Aaron Nelson says:

      Leo,
      Thanks for the comment!

      How long does that take you to link all of those tables? After you’re done, is the data stored inside the Excel Workbook(s)?

      One of the things I like about this approach is that it doesn’t depend on having Excel installed. All I need it the ImportExcel module and I’m able to export all that data to an Excel file. No add-ins, no drivers, just one module.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.