- Currently we have the export to csv,excel using the UI.
Is there is an api to do it programmatically. Please let me know.
Forum Discussion
Exporting data from Power BI to Excel
Hi all Does anybody know (as per the post below) when 'export data to CSV' was actually implemented in PBI Desktop ? I currently have PBI Desktop (Mar 2016) installed, but can't see it in there -...
The export to CSV is there, you click the ellipses (...) on a visual and choose "Export". The only option you have for export is CSV. For anything beyond that, you'll have to post a new Idea.
Paulx99 look in the top right corner of a visualization (...) - defaults to data.csv - as Greg_Deckler said you can rename but not change file format
EDIT: By the way after you open the data.csv and make any change (just make a column wider) and then try to save you'll see this
And as soon as you hit NO - it will default to xlsx.
Hi Sean
Appreciate your reply, but we might be talking at cross purposes here. I'm not interested in exporting the data from a visualisation in the Report screen to either CSV or Excel. What I want to be able to do is to export data from the Data screen to Excel. That's why I was looking for a File -> Export -> Excel option in the File menu. But there is no such option and there is no CSV option there either.
Paul
Please refer to my reply to Sean. What I want to be able to do is export data from the Data screen in PBI Desktop, NOT data from the Report screen in PBI Desktop. Exporting data from the Report screen to either CSV or Execl is of no interest to me.
Paulx99 I wrote about this on 8/23/15
Ctrl-A is to Select All - So I can Copy and Paste in Excel
I agree with you we should be able to do this
"Also please enable Ctrl+A (Select ALL) in the Data View - currently it works only in the Query Editor.
This way we could Select ALL Data in the Data View where it would include the Calculated Columns."Hey Sean
I'm fully aware that a CTRL-A (Select All) will let me copy and paste from the data screen (albeit in Query Editor) into Excel. That is however, not not going to 'cut the mustrad' for me ! What end's up being pasted into Excel is messy to say the least and requires reformatting. For a tool as sophisticated as PBI Desktop, it's almost embarrassing that this is currently the only way to 'export' data from the Data View in PBI Desktop to Excel.
As I said in my original post on this issue last night, I find it incredible that there is no Export option in the File menu in PBI Desktop to export data from the Data View to Excel (.xlsx). It should be a two way street - if we can import Excel data into PBI Desktop, we should be able to export PBI Desktop data back to Excel.
Glad you agree with me on this one !
Paul
Hi
I have a dashboard in Power BI Service and i'm trying to publish to web and then export to CSV.
But there is no option to export to CSV from the Dashboards.Could you tell me please if there are some way to do that.
Thanks in advance.Pablo
Hi Pablo
Sorry for the delay in getting back to you. Firstly, most of my experience has been with PBI Desktop, not PBI Service. In addition, I have only been a member of this community for a relatively short period of time. So, I am by no means an expert.
I dialed into my PBI Service account to have a look at what you have mentioned and agree there appears to be no option to export to CSV from the dashboards. The only place I can see you can do that is in the reports section.
In the absense of any other members out there having a suggestion for you on that, it might be a good enhancement request to make to make on the Power BI Ideas site.
Paul
Hi Guys,
I have just seen this thread, but this workaround might help anyone in the future:
if you want to export to csv from BI Desktop including all your calculated columns. Put a table visual, add all your fields. Press ... and export.
Hope this helps.
Natalia
Currently we have the export to csv or excel using the UI. If there is an api to do it programmatically, please let me know.
No, there is no way to do this. The Power BI REST API lets you push new data to a data set, or pull metadata, but not the raw underlying data. The export option (under the "..." menu for a visual) will export the data as the visual displays it, so if you visual aggregates the data in some way, the export will similarly be aggregated. Lastly, analyze in excel allows you to connect to the data model in Power BI service, but you are working with a power pivot data model and not the underlying data, and you need to explicitly create measures in Power BI in order to drop them into your values section of the pivot table.
