Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago
Solved

Extract data from PowerBI

Hi everyone,   I have a table of data which in Power BI i can get to do what I want however I need to extract this to excel for someone.   The data is made up of consignment numbers, wagon number...
Need Help
  • GilesWalker's avatar
    GilesWalker
    10 years ago

    Someone in IT managed to assist with this. The answer was to create a table and then enter the following formula:

     

    Train Report net Sum = SUMMARIZE('Train report master data', 'Train report master data'[Consignment], "Net Total", SUM('Train report master data'[Net]))

brendanbannon's avatar
brendanbannon
Frequent Visitor
9 years ago

Hi!

 

I found another way to extract / copy data from within Power BI for use in another application such as Excel.

 

  • Within Power BI, navigate to the DATA view (Table Icon in top left corner)
  • Right-click on the table you want to extract from the FIELDS panel on the right side of the page
  • Select "Copy Table" to copy all data to the clipboard
  • Paste the copied data into your desired location

Note: I'm not sure if there is a size limit.  This worked for me with ~20,000 rows and ~25 columns.

 

Cheers!