Forum Discussion
Power BI Desktop - Export Data Model as one table
Option 1: Power BI Desktop
- Open Power BI Desktop and go to Data View.
- Select the table you want to export.
- Copy the table data (Ctrl+A, then Ctrl+C).
- Paste it into Excel (Ctrl+V).
Option 2: Power BI Service
- Publish your report to Power BI Service.
- Open the report and select the table visual.
- Click the ellipsis (three dots) and choose Export data.
- 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.
Option 1: Power BI Desktop
- Open Power BI Desktop and go to Data View.
- Select the table you want to export.
- Copy the table data (Ctrl+A, then Ctrl+C).
- Paste it into Excel (Ctrl+V).
Option 2: Power BI Service
- Publish your report to Power BI Service.
- Open the report and select the table visual.
- Click the ellipsis (three dots) and choose Export data.
- Download the file and open it in Excel.
I would like to export the table so that i have only the values that are somehow connected in my data model. So for example if I had personell numbers and a 1 - n relation I would like to export only the entries that are connected in this relation. So if in my second table are more personell numbers than in my first one I would still only want to export the entries of the tables with a connection meaning the personell numbers that are also in table one...
