cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alexandre Frequent Visitor
Frequent Visitor

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 16
Super User
Super User

Re: Extract data from PowerBI

There is currently no way of doing that. There are no export capabilities.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator WillT
Moderator

Re: Extract data from PowerBI

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!
mrvachon Frequent Visitor
Frequent Visitor

Re: Extract data from PowerBI

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.
Highlighted
jameslo30 Member
Member

Re: Extract data from PowerBI

We as a company want this feature!!!

PJR6166 New Member
New Member

Re: Extract data from PowerBI

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.

milliganI3 New Member
New Member

Re: Extract data from PowerBI

this is basic functionality and without it diminishes the value of the whole product

GilesWalker Established Member
Established Member

Re: Extract data from PowerBI

@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

kcantor Super Contributor
Super Contributor

Re: Extract data from PowerBI

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.



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




GilesWalker Established Member
Established Member

Re: Extract data from PowerBI

@kcantor thanks for posting this. I checked over the weekend and the export to excel icon was there. However this morning it seems to have disappeared. Hope it is coming back.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)