Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Ability to export Data from PBI Desktop to Excel

Please provide the ability to export data from PBI Desktop to an Excel (.xlsx) file.
Status: Needs Votes
Comments
ThomasC
Advocate I
Yep, this would be very useful!
matteofarotti
New Member
I confirm. This function would be very useful!
paulo_c_maselli
New Member
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.
Florent3628
New Member
Main problem is the rows limit; increase the limit to 150k or add the same export features than webapp version.
rdadabhay
New Member
If the row limit was increased this would not be necessary
kate_golding
New Member
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
nerd2000
Advocate I
huge shortcoming that you can only export 30K rows in csv. This is an important enhancement
lee_caswell1
New Member
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
PatMcN64
Regular Visitor
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
bschneider2
New Member
Agreed, limitation of 30,000 rows on a data export to excel is a joke. Hope this is fixed soon.