cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MbProg Helper II
Helper II

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 Community Champion
Community Champion

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.

 

Highlighted
suryaprakashred
Regular 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 Helper II
Helper II

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?!

Microsoft
Microsoft

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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.