Power BI Desktop - Export Data Model as one table

Option 1: Power BI Desktop

1. Open Power BI Desktop and go to Data View.
2. Select the table you want to export.
3. Copy the table data (Ctrl+A, then Ctrl+C).
4. Paste it into Excel (Ctrl+V).

Option 2: Power BI Service

1. Publish your report to Power BI Service.
2. Open the report and select the table visual.
3. Click the ellipsis (three dots) and choose Export data.
4. Download the file and open it in Excel.

Hi arieG ,

Thanks manvishah17  for the quick reply. Allow me to add a little that you can create a visual in PBI Desktop, as you described, the visual should place the desired fields from Table 1 and then publish the report on the service, select the visual to export the data.

This is my test data.  

If I misunderstand your needs, please clarify in the follow-up reply.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.