Forum Discussion
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...
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]))
With the December update you can use the workaround via R to export your data from Power BI to txt or SQL-server: http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
ImkeF - thanks for the tip, and also I have saved your website in my favorites, like what you are doing please keep it going.