Forum Discussion

arieG's avatar
arieG
New Member
2 years ago
Solved

Power BI Desktop - Export Data Model as one table

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!

Need Help
  • manvishah17's avatar
    manvishah17
    2 years ago

    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.
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • manvishah17's avatar
    manvishah17
    Solution Supplier
    2 years ago

    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's avatar
      arieG
      New Member
      2 years ago

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

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.