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 menu ribbon as this 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” pop-up will be displayed.
- Select Export Data. The Which data do you want to export? window will open.
- Select the Data with current layout tile.
- Select Export.
Depending on which version operating system and web browser being used it may download directly to your Download folder or a ‘Save as’ window may be displayed allowing you to rename the file and select where the file is saved.
