Power BI Desktop - Export Data Model as one table

[arieG]

Hi everyone,

I have created a Data Model in Power BI with different relations between a few excel tables. Now I would like to export it as one new table or as an excel file. Does anyone know if this is possible?

Thank you in advance!

[manvishah17 · Accepted solution]

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.

[v-tangjie-msft · Accepted solution]

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.

[manvishah17 · Accepted solution]

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.

[arieG]

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...