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 data from Power BI.

 

You can navigate to the DATA tab (Table/Matrix Icon), right-click on the desired table to extract, and select "Copy Table" to copy the entire table to your clipboard.  You can then go to Excel or another application and paste the data.  

 

NOTE: I'm not sure if there is a size limit.  I copied ~20,000 rows and ~25 columns without issues.