Forum Discussion
Extract data from PowerBI
Hello,
Is it possible to extract data from PowerBI desktop or web app ?
I import data from PostGre DB, mashing up, create new columns and measure then design a Dashboard.
Some dashboard helop me to find some particular users in my DB, wich i report as table.
Now i need to extract them into a Excel or CSV file to send another entity.
They are no way to do this ?
Thanks,
Alexander.
16 Replies
There is currently no way of doing that. There are no export capabilities.
- Please take a look at the suggestions on https://support.powerbi.com/forums/265200-power-bi?query=export, and add your support for the ones that are most useful for you!
We as a company want this feature!!!
- Not sure if you'd want to do this.. The best practice if you plan on using the same merged data set would be to merge it outside of powerbi. Perhaps etl the data into an azure database table... Or better yet a managed data warehouse.
Power bi is great for mashing up data for reporting but it's not the right tool to use if you share data sets. I'm thinking of using Excel [Power Query (2013) or Get & Transform (2016)] to do ETL, then using the Excel file as data source for Power BI. That way data is still accessible in format that can still be shared. However, further changes to data structure are not fed back into data model in Excel so it would be a bit clunky.
this is basic functionality and without it diminishes the value of the whole product
milliganI3 - This has been answered in another message:
http://community.powerbi.com/t5/Desktop/Extract-data-from-PowerBI/m-p/13286#M3335
There are two ways of extracting data. However I do beleive the PBI team are working on other ways also.
Giles
An export to Excel button appeared yesterday hidden under the three dots in the top right corner of the report beside the "pin" icon. this exports the current report data to excel. No blog post yet regarding this but there is also now a print dashboard feature as well.
Would this R-scripting tip work for you?
require(gdata)
write.table(trim(dataset), file=”your filepath & filename.txt”, sep = “\t”, row.names = FALSE)
plot(dataset);http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
https://www.youtube.com/watch?v=56FV6x8vYyQ
There are some limitations outlined on Imke's Biccountant blog.
Hope that helps
Thanks for the suggestion. The dashboards are shared with our clients so unfortunately the R-Script would not work in this example. Since this post l have raised a ticket and the PowerBI support team have confirmed what we are seeing is a bug, they are looking at it just now.
Robert
