Skip to main content

Power BI

Needs Votes

Ability to export Data from PBI Desktop to Excel

Vote (239) Share
Paul's profile image

Paul on 30 Mar 2016 18:09:11

Please provide the ability to export data from PBI Desktop to an Excel (.xlsx) file.

Comments (19)
Paul's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:29

RE: Ability to export Data from PBI Desktop to Excel

I need the ability to have users filter on their own data and export to EXCEL - There is a single large Power-BI model with over 70 users. Currently the managers split the files and email them to the users. Having the ability to export in EXCEL is necessary - as they need to can keep track of their actions related for each line in the exported data. Allowing Self-Service to users directly to Excel, in excess of 30K records is a huge

Paul's profile image Profile Picture

Lee Caswell on 05 Jul 2020 23:37:16

RE: Ability to export Data from PBI Desktop to Excel

There are times when you simply need to extract the data to work on the file.

30K limit is rediculously low, I would even argue that 150K rows is inadequate when excel can handle 1 million+

This is a huge shortcoming in what is otherwise an excellent application. When will this be resolved

Paul's profile image Profile Picture

Power BI User on 05 Jul 2020 23:33:34

RE: Ability to export Data from PBI Desktop to Excel

huge shortcoming that you can only export 30K rows in csv. This is an important enhancement

Paul's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:41

RE: Ability to export Data from PBI Desktop to Excel

Why does PBI desktop restrict the number of rows one can download? I don't understand why there is a limit to begin with? Why can't it equal the available rows in excel? Or at the very least match the Service download limit

Paul's profile image Profile Picture

riazd on 05 Jul 2020 23:26:22

RE: Ability to export Data from PBI Desktop to Excel

If the row limit was increased this would not be necessary

Paul's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:44

RE: Ability to export Data from PBI Desktop to Excel

Main problem is the rows limit; increase the limit to 150k or add the same export features than webapp version.

Paul's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:33

RE: Ability to export Data from PBI Desktop to Excel

I tried to export data to excel (.xlsx) and only open option to (.csv). In help, we view an example that show option in excel and csv. In Excel, 150,000 rows limit is better than 30,000 rows limit from csv.

Paul's profile image Profile Picture

Matteo on 05 Jul 2020 23:18:39

RE: Ability to export Data from PBI Desktop to Excel

I confirm. This function would be very useful!

Paul's profile image Profile Picture

Tom on 05 Jul 2020 22:32:14

RE: Ability to export Data from PBI Desktop to Excel

Yep, this would be very useful!