cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MbProg Regular Visitor
Regular Visitor

How can I export data from Power BI Service to Power BI Desktop

Here http://community.powerbi.com/t5/Service/view-dataset-content/m-p/13277#M4733 smouphre says that we are able to export our data from Power BI Service to Power BI Desktop. How can I do that?

4 REPLIES 4
ankitpatira Super Contributor
Super Contributor

Re: How can I export data from Power BI Service to Power BI Desktop

@MbProg I think you misunderstood. Currently it is not possible to export data from service to desktop. The only option I can think is called Analyze in Excel that lets you connect live to your published dataset in clound and use Pivot Table.

 

suryaprakashred Frequent Visitor
Frequent Visitor

Re: How can I export data from Power BI Service to Power BI Desktop

HI @MbProg

 

right now you can only import data from power bi desktop to power bi service.But there is no way to achieve other way around.Moreover why do you require it,because you are already generating reports on top of the data you have after which you are exporting to power bi service.So why do you require the opposite way around if you already have the data???

 

 

thanks and regards,

k.surya

MbProg Regular Visitor
Regular Visitor

Re: How can I export data from Power BI Service to Power BI Desktop

@suryaprakashred The reason why I am need that is the following: I am using Power BI API to create a dataset and insert and delete rows in live time. After inserting tons of data I would like to see the raw data in tables like I was able in Power BI Desktop. Of course I could create a table visualization, but it is not as good as the tables are in Power BI Dektop. And in Power BI Service you don't have this view in the raw data that you have in Power BI Desktop. That's the reason I would like too see this new data in Power BI Dektop. And @smouphre says that this is a possible?!

Highlighted
Moderator v-yuezhe-msft
Moderator

Re: How can I export data from Power BI Service to Power BI Desktop

Hi @MbProg,

Based on smouphre’s response in this thread, he suggests to import data from original source rather than Power BI Service into Power BI Desktop and then use the data view feature.

Currently, it is not possible to export data from Power BI Service to Power BI Desktop or view the data in the dataset as a table view, if you concern about this feature, you can submit your idea on the Power BI Idea forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas .

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 63 members 1,211 guests
Please welcome our newest community members: