When you are ready to export the data from Power BI to Excel, follow these steps.
Note: DO NOT USE the EXPORT button in the top blue menu ribbon, as it will not work for our purposes.
- Hover over and select the ellipsis (three dots) in the top right corner of the data grid. A “More options” menu will appear; however, it is quite difficult to see, as it will appear over the top of the name of the column on the right-hand side of the data grid.
- Select Export Data. The "Which data do you want to export?" tile will pop up.
- Select the Data with current layout option.
- Select Export.
Depending on your operating system and web browser, the file may download directly to your Downloads folder or a “Save as” window may appear, allowing you to rename the file and choose its location.
