Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

Use the ToCSV DAX function and dynamic arrays to return whole tables from a single Excel cube formula ...

Gather, shape, analyze, and visually explore data more easily—in less time—using Excel and Power BI together.

Learn how to export Microsoft Power BI data to Excel using this step-by-step guide with examples.

Excel workbooks are one of the slowest data sources you can use with Power Query in Excel or Power BI. Reading small amounts of data from small workbooks is usually fast; reading large amounts of data ...

Excel isn't going away, but it's going to stop accumulating extra tools like barnacles. Instead Power BI Desktop will become the self-service analytics hub.