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 will appear.
- Select Export Data. The Which data do you want to export? window will open.
- 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.
