Skip to main content

Power BI

Needs Votes

Ability to export Data from PBI Desktop to Excel

Vote (128) 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 (14)
Paul's profile image Profile Picture

5d56cc7d 0cc2-438c-9c28-2b2294beab38 on 06 Jul 2020 00:15:47

RE: Ability to export Data from PBI Desktop to Excel

Hi,

Currently we can export max 30k records in Power BI. It would be good, if data export limitations increase to more.

Paul's profile image Profile Picture

11df97a2 4279-4cb8-81fc-469883fc20d2 on 05 Jul 2020 23:58:25

RE: Ability to export Data from PBI Desktop to Excel

First of all are you aware of the downfalls of the csv-file at the Microsoft?

Regional settings jungle is a nightmare when working with csv-files. Resulting nothing but tears, increased blood pressure and as a result, premature death.

Please, please, implement a way to export directly to xlsx-file. I am begging you!

Paul's profile image Profile Picture

f7434de2 6337-4689-90d0-eb875df3e354 on 05 Jul 2020 23:51:43

RE: Ability to export Data from PBI Desktop to Excel

must have features.

Paul's profile image Profile Picture

471f0f4a d5a7-4482-8786-775cb4137091 on 05 Jul 2020 23:50:30

RE: Ability to export Data from PBI Desktop to Excel

This is a ridiculous short-coming. The logic is basically the same regardless of the platform. This should be a no-brainer to implement for the great and powerful devs at MS.

Paul's profile image Profile Picture

3200d639 7304-41b4-b7e8-00e6ca952080 on 05 Jul 2020 23:49:36

RE: Ability to export Data from PBI Desktop to Excel

Agreed, limitation of 30,000 rows on a data export to excel is a joke. Hope this is fixed soon.

Paul's profile image Profile Picture

466076c8 dc5b-483a-8c5f-b1bd805523dc 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

e86a11df ea0d-43c9-864b-4983054b9ba7 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

31adfbfd 9c76-476e-9c4d-fb99e3ac0516 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

d6db1d06 825b-462a-a51e-39597eb5f787 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

32a177cb 781a-462e-a232-9c50ba2e3187 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